-
SELECTUSER_CONS_COLUMNS.CONSTRAINT_NAME AS 约束名,USER_CONS_COLUMNS.TABLE_NAME AS 表名,USER_CONS_COLUMNS.COLUMN_NAME AS 列名,USER_CONS_COLUMNS.POSITION AS 位置FROMUSER_CONSTRAINTSJOIN USER_CONS_COLUMNSON (USER_CONSTRAINTS.CONSTRAINT_NAME= USER_CONS_COLUMNS.CONSTRAINT_NAME)WHERECONSTRAINT_TYPE = 'P';注: 最后那里的 WHERE 填写的条件的注意:C (check constraint on a table) C 表示 CHECK 约束。P (primary key) P 表示主键U (unique key) U 表示唯一R (referential integrity) P 表示引用(外键)V (with check option, on a view)O (with read only, on a view)
转载于:https://www.cnblogs.com/wuxi/archive/2012/10/22/2733824.html