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
You can join the three tables
select * from sys.Tables, sys.indexes, sys.index_columns
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.