Declarative Referential Integrity (DRI)


Show Column References - Shows the column references (PK, FK, AK, INDEX) for all columns in one or all tables in a database.

Get Foreign Key Details - Returns the tables and columns involved in FK relationships in a DB. Parameter can be a single table or NULL for all tables in a DB.

Generate Commands to Enable/Disable Triggers - For SQL Server 2000 and earlier, DML trigger commands only are generated. For SQL Server 2005 and later, both DML and DDL trigger commands are generated.

Generate Commands to Enable/Disable Foreign Keys - Generates commands only for tables that have FK constraints defined.

Get Primary Key Details - Returns the tables and columns involved in PK relationships in a DB. Parameter can be a single table or NULL for all tables in a DB.

Generate Commands to Create/Drop PKs - Returns 2 lists, one containing the commands to drop all PKs in a database, the other to create them.

Generate Commands to Create/Drop FKs - Returns 2 lists, one containing the commands to drop all FKs in a database, the other to create them.

Get Constraints Metadata - Multiple queries to return summary or detail lists of constraints in a single database

Get PK and FK Metadata - Multiple queries to return summary or detail lists of PKs and FKs in a single database

Get all Database DRI - Lists all DRI for a single database