2010-03-01から1ヶ月間の記事一覧

自分メモ

FK一覧を取得 SELECT FK.name,OBJ.name FROM sys.foreign_keys AS FK INNER JOIN sys.objects AS OBJ ON OBJ.object_id = FK.parent_object_id FK全部消す DECLARE @sql VARCHAR(500), @tableName VARCHAR(128), @fkName VARCHAR(128) DECLARE triggerCursor…