create table tb(id int primary key,name varchar(10))declare @pkname varchar(30) ,@sql varchar(800)
select top 1 @pkname=name from sysobjects
where xtype='pk'and name like 'PK__tb%'
set @sql='alter table tb drop constraint '+@pkname
exec(@sql)
select top 1 @pkname=name from sysobjects
where xtype='pk'and name like 'PK__tb%'
set @sql='alter table tb drop constraint '+@pkname
exec(@sql)
期待更多的指点,我会尽快结贴!
用游标:declare @pkname varchar(30)
declare roy cursor for select name from sysobjects
where xtype='pk'and name like 'PK__tb%'
open roy
fetch next from roy into @pkName
while @@fetch_status=0
begin
declare @sql varchar(1000)
set @sql='alter table tb drop constraint '+@pkname
exec(@sql)
fetch next from roy into @pkName
end
close roy
deallocate roy