Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008
    Posts
    24

    Exclamation Unanswered: drop indexes of a particular owner id

    Hi,
    Is there any command to drop the indexes of a particular owner?

    DROP INDEX [WHERE owner = XXXX];

    Thanks

  2. #2
    Join Date
    Sep 2010
    Location
    Germany, Brunswick
    Posts
    55
    No but there is a way to delete them:

    Code:
    select  "DROP INDEX "||trim(owner)||"."||trim(idxname)||";" 
    from    sysindexes 
    where   owner="informix";
    run, copy, paste, run, be happy

    Nicer version with DBAccess
    Code:
    select  "INDEX "||trim(owner)||"."||trim(idxname)||";" DROP
    from    sysindexes 
    where   owner="informix";
    You can also build a stored procedure to do this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •