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  


Popular posts from this blog

WPF Crystal Report Viewer Using SAP

mvc razor textboxfor change event change another textboxfor value

ASP.NET MVC razor SAP Crystal report