2019怎么查看表的key?
1:利用SQL自帶的存儲過程 EXEC sp_pkeys @table_name='表名' 2:利用系統表INFORMATION_SCHEMA.KEY_COLUMN_USAGE SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME='表名'
2019怎么查看表的key?
1:利用SQL自帶的存儲過程 EXEC sp_pkeys @table_name='表名' 2:利用系統表INFORMATION_SCHEMA.KEY_COLUMN_USAGE SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME='表名'