Things I Learned Today

All Things Enterprise Vault with a sprinkling of everything else

Menu
  • About Me
  • EV Videos
  • Windows Videos
  • Other Videos
Menu

Dropping in SQL

Posted on June 16, 2008 by Rob Wilcox

After a little sojourn in to the world of creating new indices, I then had to clear up a little bit. Here is how to delete an index :

Drop Index

You can delete an existing index in a table with the DROP INDEX statement.

Syntax for Microsoft SQLJet (and Microsoft Access):

DROP INDEX index_name ON table_name

Syntax for MS SQL Server:

DROP INDEX table_name.index_name

Syntax for IBM DB2 and Oracle:

DROP INDEX index_name

Syntax for MySQL:

ALTER TABLE table_name DROP INDEX index_name

Seems that various methods work at least on Microsoft SQL 2005, for example this worked for me :

drop INDEX [IX_Vault_Items] on vault

Note: idea taken from http://www.w3schools.com/SQL/sql_drop.asp

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Search

Have a look at more of my instagrams

robwilc

Instagram post 2191883967647582565_6386916 @ponchthemalshi getting ready to ruuuuun on the #beach
Instagram post 2191346228925688393_6386916 @ponchthemalshi says he absolutely has to chase the sand that @art.cw20 kicked into the sea
Instagram post 2190627531479228057_6386916 Outdoor cinema in Perth.
Instagram post 2188372971561844120_6386916 Great walking along the #beach #nofilter
Instagram post 2187018555017594204_6386916 Inside Fremantle Prison
Follow on Instagram
  • Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
© 2019 Things I Learned Today | Powered by Minimalist Blog WordPress Theme