alter table table1 drop CONSTRAINT
(select b.name from syscolumns a,sysobjects b where a.id=object_id('table1')
and b.name like 'DF%'
and b.id= a.cdefault AND
a.[name]='tableColumn'
)这样写总报错,哪里的问题?
(select b.name from syscolumns a,sysobjects b where a.id=object_id('table1')
and b.name like 'DF%'
and b.id= a.cdefault AND
a.[name]='tableColumn'
)这样写总报错,哪里的问题?
set @s=(select b.name from syscolumns a,sysobjects b where a.id=object_id('table1')
and b.name like 'DF%'
and b.id= a.cdefault AND
a.[name]='tableColumn'
)alter table table1 drop CONSTRAINT @s
select @s = b.name from syscolumns a,sysobjects b where a.id=object_id('table1')
and b.name like 'DF%'
and b.id= a.cdefault AND
a.[name]='tableColumn' alter table table1 drop constraint @s
没办法一条sql 解决吗?
set @s=(select b.name from syscolumns a,sysobjects b where a.id=object_id('table1')
and b.name like 'DF%'
and b.id= a.cdefault AND
a.[name]='tableColumn'
)alter table table1 drop CONSTRAINT @s
不能通过一条SQL 搞定?