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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drop Index produces "does not exist in the system catalog"

Status
Not open for further replies.
May 7, 2001
9
US
I have run sp_helpindex 'TableName' on a table in a production database. It returns over 20 indexes with a description of "nonclustered, statistics, auto create located on PRIMARY"
These indexes cannot be dropped. "Drop Index TableName.IndexName produces "does not exist in the system catalog".
Questions:
1. Where are these indexes coming from?
2. Are they important?

Thanks
Lou Burgoyne
 

The statistics are auto created by SQL Server. They are important in optimizing queries. Although not recommended, you can drop statistics with the "DROP STATISTICS" statement. Set SQL BOL for details. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top