复制SELECT t.TABLE_NAME,数速获 t.CONSTRAINT_TYPE, c.COLUMN_NAME, c.ORDINAL_POSITION FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS t, INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS c WHERE t.TABLE_NAME = c.TABLE_NAME AND t.CONSTRAINT_TYPE = PRIMARY KEY AND t.TABLE_NAME = <TABLE_NAME> AND t.TABLE_SCHEMA = <TABLE_SCHEMA>; 1.2.3.4.5.6.7.8.9.10.11.12.13.