Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dropping an index?

Status
Not open for further replies.

golyg

Programmer
Jul 22, 2002
319
US
When I run a statement to drop an index should I include the table_name??
like
DROP INDEX index_name ON table_name
or like this
DROP INDEX index_name


I have been receiving syntax errors for the first statement eventhough it seems more complete.
which one do I use?

thanks,
 
Your short second example is perfect
HTH ;-) Dickie Bird
db@dickiebird.freeserve.co.uk
 
Thanks alot,
I am concerned that it may drop an index of the same name for a different table.
Or is it not a standard to have the same index name for other tables.

TIA,
m
 
Any index I create always has the following conventions:
tablename_idx1 ..2 ..3 etc
;-) Dickie Bird
db@dickiebird.freeserve.co.uk
 
I think the index name is unique throw the system. And I think this is part of standard SQL (core-92 and core-99).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top