摘要:
取得表中主键:select primaryKey=COLUMN_NAME from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGEWHERE CONSTRAINT_NAME=(select CONSTRAINT_NAME from INFORMATION_SCHEMA.TABLE_CONSTRAINTSWHERE CONSTRAINT_TYPE='PRIMARY KEY' AND TABLE_NAME='表名')取得表的其它有用信息: select * from INFORMATION_SCHEMA.CONSTRAINT_C 阅读全文