Skip to content

Instantly share code, notes, and snippets.

@akuchotrani

akuchotrani/Deleting index

Created July 31, 2019 07:07
Show Gist options
  • Save akuchotrani/e387e5bd7644781f85944e88016b42ac to your computer and use it in GitHub Desktop.
Save akuchotrani/e387e5bd7644781f85944e88016b42ac to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Deleting index
--MS Acess
DROP INDEX index_name ON table_name;
--SQL Server
DROP INDEX table_name.index_name;
--DB2/Oracle:
DROP INDEX index_name;
--MySQL:
ALTER TABLE table_name
DROP INDEX index_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment