Hi Team,
How do I get a listing of all the current constraints in a database please?
I know there is are Constraints and a ConstraintColumns tables.
Regards & TIA,
Ian

Ian


You've already (almost) spotted the answer

select * from information.constraints

or

select * from information.constraintcolumns


replace * with the columns you want

The tables in the information database can be queried just like any other table so you can ORDER BY, GROUP BY etc to get what you want. Check out the OLH for Information Schema (and Configuration Database for more useful tables)

Roy Lambert

Thanks Roy.
All good.
Regards,
Ian