drop.vm

来自「torque服务器源代码」· VM 代码 · 共 10 行

#foreach ($fk in $table.ForeignKeys)
IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND name='$fk.Name')
    ALTER TABLE $table.Name DROP CONSTRAINT $fk.Name;
#end
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = '$table.Name')
BEGIN
	DROP TABLE $table.Name
END
;