10-05-2010 07:26 AM
Hi,
I create my clustered index on one of the table in MSSQL. I would like to check if this index is existed or not. But my problem I could not release where is usually SalesLgix save indexes... In which table..
I used sp_tables but still there is some views I could not retrieve there data...
Any suggestions....
Thanks.
Solved! Go to Solution.
10-05-2010 11:29 AM
I think I found it...
Should be
SELECT name FROM sys.sysindexes where name = 'Index_name'