本文共 956 字，大约阅读时间需要 3 分钟。

???????????????????????????????????????????????????????????????????????????

MYSQL ???????

?MYSQL????????????????SQL???????????????????????????

SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGEWHERE TABLE_NAME > 'dtproperties'AND TABLE_NAME = 'YOUR_TABLE_NAME';

?????????????????????????dtproperties ????????????????????????

ORACLE ???????

??ORACLE???????????????????????????????

SELECT A.OWNER, A.TABLE_NAME, B.COLUMN_NAME, C.OWNER, C.TABLE_NAME, D.COLUMN_NAMEFROM USER_CONSTRAINTS ALEFT JOIN USER_CONS_COLUMNS B ON A.CONSTRAINT_NAME = B.CONSTRAINT_NAMELEFT JOIN USER_CONSTRAINTS C ON C.R_CONSTRAINT_NAME = A.CONSTRAINT_NAMELEFT JOIN USER_CONS_COLUMNS D ON C.CONSTRAINT_NAME = D.CONSTRAINT_NAMEWHERE A.CONSTRAINT_TYPE = 'P'AND A.TABLE_NAME = 'YOUR_TABLE_NAME'ORDER BY A.TABLE_NAME;

????????????????????????????????????????YOUR_TABLE_NAME ????????????????????????

???????????????????????????????????????????????????????????????????????

转载地址：http://orqk.baihongyu.com/