How do I drop the index related to a primary key? DROP INDEX doesn't work..

A. Because the index is built as part of a constraint, the way to drop it is to drop the constraint :-

ALTER TABLE <tablename> DROP CONSTRAINT ....


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish