请问如何查找unique constraint 是对哪个表的约束？

Question

SQL> select object_name  from all_objects where object_name  like '%CONSTRAINT%';
OBJECT_NAME
------------------------------
ALL_CONSTRAINTS
DBA_CONSTRAINTS
DBA_IAS_CONSTRAINT_EXP
LOADER_CONSTRAINT_INFO
USER_CONSTRAINTS
ALL_CONSTRAINTS
DBA_CONSTRAINTS
LOADER_CONSTRAINT_INFO
USER_CONSTRAINTS已选择9行。SQL> desc user_constraints
 名称                                     空?      类型
 ---------------------------------------- -------- ---------------------------
 OWNER                                    NOT NULL VARCHAR2(30)
 CONSTRAINT_NAME                          NOT NULL VARCHAR2(30)
 CONSTRAINT_TYPE                                   VARCHAR2(1)
 TABLE_NAME                               NOT NULL VARCHAR2(30)
 SEARCH_CONDITION                                  LONG
 R_OWNER                                           VARCHAR2(30)
 R_CONSTRAINT_NAME                                 VARCHAR2(30)
 DELETE_RULE                                       VARCHAR2(9)
 STATUS                                            VARCHAR2(8)
 DEFERRABLE                                        VARCHAR2(14)
 DEFERRED                                          VARCHAR2(9)
 VALIDATED                                         VARCHAR2(13)
 GENERATED                                         VARCHAR2(14)
 BAD                                               VARCHAR2(3)
 RELY                                              VARCHAR2(4)
 LAST_CHANGE                                       DATESQL>

Answer 1

我希望，这是告诉你一种方法，而不仅仅是告诉你怎么查约束这么个东西
SQL> select object_name  from all_objects where object_name  like '%CONS%';
OBJECT_NAME
------------------------------
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_IAS_CONSTRAINT_EXP
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS
DEFAULT_CONSUMER_GROUP
GV_$RSRC_CONSUMER_GROUP
GV_$RSRC_CONSUME_GROUP_CPU_MTH
LOADER_CONSTRAINT_INFO
ODCICONST
RESOURCE_CONSUMER_GROUP$
SM$INTEGRITY_CONS
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_RSRC_CONSUMER_GROUP_PRIVS
V_$RSRC_CONSUMER_GROUP
V_$RSRC_CONSUMER_GROUP_CPU_MTH
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS
GV$RSRC_CONSUMER_GROUP
GV$RSRC_CONSUMER_GROUP_CPU_MTH
LOADER_CONSTRAINT_INFO
ODCICONST
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_RSRC_CONSUMER_GROUP_PRIVS
V$RSRC_CONSUMER_GROUP
V$RSRC_CONSUMER_GROUP_CPU_MTH
/4373969e_CONST
/7e8ba6b6_CONSTFormatInfo
ORDIMAGECONSTANTS已选择37行。SQL> SQL> desc USER_CONS_COLUMNS
 名称                                     空?      类型
 ---------------------------------------- -------- ---------------------------
 OWNER                                    NOT NULL VARCHAR2(30)
 CONSTRAINT_NAME                          NOT NULL VARCHAR2(30)
 TABLE_NAME                               NOT NULL VARCHAR2(30)
 COLUMN_NAME                                       VARCHAR2(4000)
 POSITION                                          NUMBERSQL> 

Answer 2

我希望，这是告诉你一种方法，而不仅仅是告诉你怎么查约束这么个东西
SQL> select object_name  from all_objects where object_name  like '%CONS%';
OBJECT_NAME
------------------------------
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_IAS_CONSTRAINT_EXP
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS
DEFAULT_CONSUMER_GROUP
GV_$RSRC_CONSUMER_GROUP
GV_$RSRC_CONSUME_GROUP_CPU_MTH
LOADER_CONSTRAINT_INFO
ODCICONST
RESOURCE_CONSUMER_GROUP$
SM$INTEGRITY_CONS
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_RSRC_CONSUMER_GROUP_PRIVS
V_$RSRC_CONSUMER_GROUP
V_$RSRC_CONSUMER_GROUP_CPU_MTH
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS
GV$RSRC_CONSUMER_GROUP
GV$RSRC_CONSUMER_GROUP_CPU_MTH
LOADER_CONSTRAINT_INFO
ODCICONST
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_RSRC_CONSUMER_GROUP_PRIVS
V$RSRC_CONSUMER_GROUP
V$RSRC_CONSUMER_GROUP_CPU_MTH
/4373969e_CONST
/7e8ba6b6_CONSTFormatInfo
ORDIMAGECONSTANTS已选择37行。SQL> SQL> desc USER_CONS_COLUMNS
 名称                                     空?      类型
 ---------------------------------------- -------- ---------------------------
 OWNER                                    NOT NULL VARCHAR2(30)
 CONSTRAINT_NAME                          NOT NULL VARCHAR2(30)
 TABLE_NAME                               NOT NULL VARCHAR2(30)
 COLUMN_NAME                                       VARCHAR2(4000)
 POSITION                                          NUMBERSQL> 

Answer 3

向biti_rainy(biti_rainy) 兄学习