【轉(zhuǎn)】【SQL Server】查詢數(shù)據(jù)表主鍵及主鍵類型
詳細(xì)內(nèi)容查看:https://blog.csdn.net/weixin_43347659/article/details/120829241
查詢某個表的主鍵名稱:
select c.name from sys.indexes i join sys.index_columns ic on i.object_id = ic.object_id and i.index_id = ic.index_id join sys.columns c on ic.object_id = c.object_id and ic.column_id = c.column_id where i.is_primary_key = 1 and i.object_id = object_id('u_store_i')

浙公網(wǎng)安備 33010602011771號