Posts

Showing posts from June, 2020

Find all the PRIMARY KEY of a database table in SQL SERVER

Image
Here is the query: select schema_name(tab.schema_id) as [schema_name],     pk.[name] as pk_name,     substring(column_names, 1, len(column_names)-1) as [columns],     tab.[name] as table_name from sys.tables tab     inner join sys.indexes pk         on tab.object_id = pk.object_id         and pk.is_primary_key = 1    cross apply (select col.[name] + ', '                     from sys.index_columns ic                         inner join sys.columns col                             on ic.object_id = col.object_id...