Cool Tips‎ > ‎

Declarative Referential Integrity (DRI)

 

Title

Description

Applicability

 

Show Column References

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


2000, 2005, 2008, 2008R2, 2012


 

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.


2000, 2005, 2008, 2008R2, 2012 

 

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.



2000, 2005, 2008, 2008R2, 2012 

 

Generate Commands to Enable/Disable Foreign Keys

Generates commands only for tables that have FK constraints defined.


2000, 2005, 2008, 2008R2, 2012 

 

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.


2000, 2005, 2008, 2008R2, 2012  

 

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. 


2000, 2005, 2008, 2008R2, 2012 

 

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. 


2000, 2005, 2008, 2008R2, 2012 

 

 


Comments