Hi,
How can i get the Table Name,type of Index,Index column name for all the tables in the database.
Thanks in Advance.
USE YourDatabase GO select * from sys.Tables select * from sys.indexes select * from sys.index_columns
that's k.
but my Requirment was in a single query i would like to display the tablename,Index Name,Index Description and IndexKeys.
Thanks in Advance...
You can join the three tables
select * from sys.Tables, sys.indexes, sys.index_columns
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.