问我想知道我在sql中发出主键的列名？语法是什么？

EN

SELECT DISTINCT TABLE_NAME ,column_name
FROM INFORMATION_SCHEMA.key_column_usage
WHERE TABLE_SCHEMA IN ('*your_schema_name*');

USE databasename; 

GO
 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