Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Listing of current constraints in a database? |
Mon, Mar 9 2020 10:17 PM | Permanent Link |
Ian Branch | 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 |
Tue, Mar 10 2020 2:54 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Tue, Mar 10 2020 4:52 AM | Permanent Link |
Ian Branch | Thanks Roy.
All good. Regards, Ian |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |