--删除表之前，先删除所有的字段约束 DECLARE c1 cursor for select 'alter table ['+ object_name(parent_obj) + '] drop constraint ['+name+']; ' from sysobjects where xtype = 'F' open c1 declare @c1 varchar(80

--禁止约束 DECLARE DEL_CONSTRAINT CURSOR FOR SELECT 'ALTER TABLE '+OBJECT_NAME(PARENT_OBJ)+' NOCHECK CONSTRAINT '+NAME+';' FROM SYSOBJECTS A LEFT OUTER JOIN SYSCOMMENTS B ON A.ID = B.ID WHERE A.XTYPE =

DECLARE @TabName VARCHAR(100) DECLARE test_Cursor CURSOR LOCAL FOR SELECT Name FROM SysObjects Where XType='U' ORDER BY Name OPEN test_Cursor FETCH NEXT FROM test_Cursor INTO @TabName WHILE @@FETCH