在oracle 中，如何查询已经建立好的约束，如：外键，check,还有sequence?

显示全部楼层 · 2011-8-29 20:53:57

主键约束SELECTUSER_CONS_COLUMNS.CONSTRAINT_NAME AS 约束名,USER_CONS_COLUMNS.TABLE_NAME AS 表名,USER_CONS_COLUMNS.COLUMN_NAME AS 列名,USER_CONS_COLUMNS.POSITION AS 位置FROMUSER_CONSTRAINTS
JOIN USER_CONS_COLUMNS
ON (USER_CONSTRAINTS.CONSTRAINT_NAME
= USER_CONS_COLUMNS.CONSTRAINT_NAME)WHERECONST...

千问 · 2011-8-29 20:53:57

select * from user_constraints;select * from user_sequences;你当前用户所创建的约束和序列...

千问 · 2011-8-29 20:53:57

select * from user_constraints; --约束,checkselect * from seq; --sequence...

千问 · 2011-8-29 20:53:57

select * from dba_constraints ;select * from dba_sequences ;分别查询约束和序列...