Skip to main content

Get all constraints in Oracle

 To get all the constraints created in Oracle database, use below query.


            SELECT * FROM USER_CONSTRAINTS;

If you want to get the constraints created for a particular user then use below SQL query.


            SELECT * FROM USER_CONSTRAINTS where owner = 'userName';
Labels:

Comments

  1. Noah30 August 2021 at 01:47

    If you want to get the more clear information like columns then use the below SQL query:

    SELECT constraint_name, constraint_type, column_name from user_constraints natural join user_cons_columns where table_name = 'tableName';

    ReplyDelete

Post a Comment

Popular posts from this blog

Table and its count

Table and its count To view all tables and its count by executing command and immediately, use below commands - MSSQL SELECT      sc. name   + '.' + ta. name   TableName,  SUM (pa. rows ) RowCnt FROM      sys.tables ta INNER   JOIN   sys.partitions pa      ON   pa.OBJECT_ID = ta.OBJECT_ID INNER   JOIN   sys.schemas sc      ON   ta.schema_id = sc.schema_id WHERE   ta.is_ms_shipped = 0  AND   pa.index_id  IN   (1,0) GROUP   BY   sc. name ,ta. name ORDER   BY   SUM (pa. rows )  DESC  
Post a Comment
Read more