Help - Search - Members - Calendar
Full Version: system generated constraints
Oracle DBA Forums > Oracle > Oracle Forum
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 ?


>> 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:

Here is what a check constraints does:
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 ....


>> 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:
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2016 Invision Power Services, Inc.