Thursday, January 12, 2017

sql get all table names with primary key columns

If you want to get all table name with table primary key coloumn you can use the sql query.


 SELECT i.name AS IndexName, OBJECT_NAME(ic.OBJECT_ID) AS TableName,   
     COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName  
 FROM sys.indexes AS i  
 INNER JOIN sys.index_columns AS ic  
 ON i.OBJECT_ID = ic.OBJECT_ID  
 AND i.index_id = ic.index_id  
 WHERE i.is_primary_key = 1  


SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...