If i want to see the Index deatils for a given table say 'ABC' how can i do it? I need
INDEX_NAME, COLUMN_NAME, TABLE_NAME, INDEX_TYPE columns for
In oracle i am able to find it out from the query mentioned below,
select B.INDEX_NAME, B.COLUMN_NAME, B.TABLE_NAME, A.INDEX_TYPE from USER_INDEXES A,
USER_IND_COLUMNS B
where B.TABLE_NAME = 'ABC' AND A.INDEX_NAME = B.INDEX_NAME
order by 3;
Please tell me how to do it in SQL Server? My mail ID is, kama_biet@rediffmail.com
Regards...
Sujit
Start Free Trial
