第1个回答 2011-05-25
SQL> select owner,constraint_name,CONSTRAINT_TYPE,table_name from user_constraints;
OWNER CONSTRAINT_NAME C TABLE_NAME
------------------------------ ------------------------------ - -----------------------
SCOTT PK_DEPT P DEPT
SCOTT PK_EMP P EMP
SCOTT FK_DEPTNO R EMP