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

Indexes in database

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.

Highlighted
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'