What would be the proper syntax to return all the constraints in a db.

Roger

Hello,

if you use Oracle try

SELECT owner, constraint_name, constraint_type, status, delete_rule
FROM sys.all_constraints

Hope that helps ?

Best regards

Manfred Peter
(Alligator Company)
http://www.alligatorsql.com

Thanks, that worked for all the dbs in my schema, but how would I use that to pertain to one specific db

Hello,

I don´t know exactly what you mean. If you use this statement you get all constraints in you db independent from your schema.
The best way to get all constraints is to connect as SYS and start the select.

Is that not what you are looking for ?

Manfred Peter
(Alligator Company)
http://www.alligatorsql.com

In my schema I have two db's and I was wondering if it is possible to query just the constraints of just one db

I think maybe you meant to say "In my DB I have two schemas...". The OWNER of a constraint is the SCHEMA that is belongs to. A SCHEMA does not have multiple DBs, a DB can have multiple SCHEMAs.