MS Sql Server - Tips and Tricks

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/********************* DROP ALL FOREIGN KEYS ***********************/

DECLARE fk CURSOR FOR

SELECT t1.name, t2.name AS fkTable, t3.name ...