Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
New Member
Posts: 3
Registered: ‎10-05-2010
Accepted Solution

Indexes in database



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....



New Member
Posts: 3
Registered: ‎10-05-2010

Re: Indexes in database

I think I found it...


Should be


SELECT name FROM sys.sysindexes where name = 'Index_name'