How to delete a entry for a hidden index

Laura Draguli

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

How to delete a entry for a hidden index

Hello
I have some entries in the sysindexes table which are generated by MSSQL.
Does anybody know how can entries cand be deleted ?
If i try the command DROP INDEX .... the message is : "The index does not
exists",
but i can see the index with a select from sysobjects or sp_helpindex.
These indexes have the 5th bit in status field set on 1.

Any suggestion would be apreciate.

Thanx,
Laura

Laura Draguli

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:How to delete a entry for a hidden index

The problem is solved thanx to "Books Online"

The index was in fact a statistics, and i deleted with DROP STATISTICS ....
Anyway, is strange this SQLDMOIndex_Hypothetical is strange.
It is generated automaticaly, and if auto update statistics is on, the
update for the table is slow,
because of rebuilding these indexes.

Quote

Laura Dragulin <la...@ats.minisat.ro> wrote in message

news:8qsqab$8d912@bornews.borland.com...

Quote

> Hello
> I have some entries in the sysindexes table which are generated by MSSQL.
> Does anybody know how can entries cand be deleted ?
> If i try the command DROP INDEX .... the message is : "The index does not
> exists",
> but i can see the index with a select from sysobjects or sp_helpindex.
> These indexes have the 5th bit in status field set on 1.

> Any suggestion would be apreciate.

> Thanx,
> Laura

Other Threads

1. preventing entries being deleted when primary key is deleted

2. Hiding Taskbar entry.

3. Hiding Entries in TCheckListBox

4. Deleting/ Changing Index Value when Index Active

5. Problem deleting the entries from a batch TADODataSet

6. Deleting a string entry

7. Fastest way to manipulate/delete StringList entries

8. Deleting TDBGrid entries fed by a TQuery

9. How to delete entries through a query

10. Handling duplicate index entries