--查詢主鍵信息
SELECT
TABLE_NAME,COLUMN_NAME
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
TABLE_NAME=
'表名'
--查詢主鍵信息
SELECT
TABLE_NAME,COLUMN_NAME
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
TABLE_NAME=
'表名'