ForeignKeys.sql 739 Bytes
Newer Older
dwentzel's avatar
dwentzel committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
/*
	This script holds the MasterData about our FK Constraints
	Simply modify this metadata and rerun the MD3 deployment and any FK constraint changes
		will be reflected in your database.  
 
	To add a new FK constraint...Add a new INSERT line to the file.
	To modify a FK constraint...Modify the values of the EXISTING check constraint
	To delete a FK constraint...Set the DropConstraint flag to 1.  Do not actually delete the row.
 
 This script can be automatically regenerated by running MD3.ScriptFKConstraintTable
*/
SET NOCOUNT ON
--remove all old entries from table
TRUNCATE TABLE MD3.FKConstraints
 
--add new entries to table




--now building FK Constraints
EXEC MD3.RunFKConstraints
GO
SET NOCOUNT OFF