check the data dictionary tables user_constraints user_cons

Where the integrity constrints are stored in Data
Dictionary?

Question Posted / tulsi

Answer Posted / tulsi

check the data dictionary tables
user_constraints
user_cons_columns

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how can you create an empty table from an existing table? : Sql dba

1154

What is difference between rank () row_number () and dense_rank () in sql?

1101

What is difference between sql and excel?

1095

What are the possible values for the boolean data field?

963

How many types of triggers are there in pl sql?

1067

what are the different functions in sorting an array? : Sql dba

1023

How many parts of a pl sql block are optional?

1135

Can we use insert statement in function?

1003

What is meant by temporal data?

969

What type of database is sql?

1026

Is coalesce faster than isnull?

966

List out the acid properties and explain?

953

how to rename an existing column in a table? : Sql dba

1020

Define SQL and state the differences between SQL and other conventional programming Languages?

1217

How do I clear the screen in sql plus?

1042