system generated constraints Options

[rokyj055]

Hi All ,


I was wondering with dba_constraints and i found unexpected result shown as below

select constraints_name, constraint_type from dba_constraints

constraint_name constraint_type
SYS_C00141 c
SYS_C00142 c
SYS_C00143 c
SYS_C00144 c
SYS_C00145 c
SYS_C00146 c
SYS_C00147 c
SYS_C00148 c
SYS_C00149 c


i jst want to know that what is this system generated constraints ?

[burleson]

Hi,

>> i jst want to know that what is this system generated constraints ?

Your query is not complete enough to show the full details, but they look like "check" constraints".

Run the script here:

http://www.dba-oracle.com/t_dba_constraints.htm

Here is what a check constraints does:

http://www.dba-oracle.com/t_oracle_check_constraint.htm

[rokyj055]

Dear Sir ,
Thanx for reply
you are right that these constraints are of "Check" constraints .

But i havent created them ,
then why these have been created ??


please reply ....

[burleson]

Hi,

>> why these have been created ??

They may be part of the Oracle data dictionary, you need to dig deeper to see!



1 - Query dba_constraints to get the table name

2 - Run dbms_metadata to get the table definition, and the check constraoints will appear. Here's how:


http://www.dba-oracle.com/art_builder_get_schema_syntax.htm