Oracle find a constraint

Question

I have a constraint called users SYS C00381400   How do I find what that constraint is   Is there a way to query all constraints

User · Answer

maybe this can help    SELECT constraint name  constraint type  column name from user constraints natural join user cons columns where table name    my table name

User · Answer

select   from all constraints where owner     lt NAME gt   and constraint name    SYS C00381400      Like all data dictionary views  this a USER CONSTRAINTS view if you just want to check your current schema and a DBA CONSTRAINTS view for administration users   The construction of the constraint name indicates a system generated constraint name   For instance  if we specify NOT NULL in a table declaration   Or indeed a primary or unique key   For example   SQL gt  create table t23  id number not null primary key    2     Table created   SQL gt  select constraint name  constraint type   2  from user constraints   3  where table name    T23    4     CONSTRAINT NAME                C ------------------------------ - SYS C00935190                  C SYS C00935191                  P  SQL gt     C  for check   P  for primary     Generally it s a good idea to give relational constraints an explicit name    For instance  if the database creates an index for the primary key  which it will do if that column is not already indexed  it will use the constraint name oo name the index   You don t want a database full of indexes named like SYS C00935191     To be honest most people don t bother naming NOT NULL constraints

User · Answer

To get a more detailed description  which table column references which table column  you can run the following query   SELECT   uc constraint name  CHR 10                  ucc1 TABLE NAME       ucc1 column name      constraint source             REFERENCES   CHR 10                  ucc2 TABLE NAME       ucc2 column name      references column FROM user constraints uc     user cons columns ucc1     user cons columns ucc2 WHERE uc constraint name   ucc1 constraint name AND uc r constraint name   ucc2 constraint name AND ucc1 POSITION          ucc2 POSITION -- Correction for multiple column primary keys  AND uc constraint type      R  AND uc constraint name      SYS C00381400  ORDER BY ucc1 TABLE NAME     uc constraint name    From here

[sql] Oracle find a constraint

Examples related to sql

Examples related to oracle

Examples related to constraints