Sage SalesLogix
  • Contact Us
  • Sage North America
800-643-6400
Welcome Twitter Facebook LinkedIn
Community Home Blogs Share Ideas Search Request Access Resources
Reply
New Member
Queen
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.

Please use plain text.
New Member
Queen
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'

Please use plain text.