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 Chriss Miller 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.
Joined
May 7, 2001
Messages
9
Location
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