Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005

    Unanswered: how to delete unique index

    hi i accidentally created a unique index and i want to drop it, so i was wondering what the command is for that. I tried 'alter table drop constraint' and 'drop index' command but it didn't work, maybe i didn't call it properly. So i would really appreciate if someone can kindly help me out here, thanks.

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Is is usually done like this:
    SQL> create unique index iloc on dept (loc);
    Index created.
    SQL> drop index iloc;
    Index dropped.
    To drop an index, it must be in your own schema or you must have the DROP ANY INDEX system privilege.

Posting Permissions

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