create table test_table( test_column varchar(20) default 'aa' ) go--删除默认 declare @s nvarchar(4000) select @s=N'ALTER TABLE '+QUOTENAME(ot.name) +N' DROP CONSTRAINT '+QUOTENAME(oc.name) -- ,tbname=oc.name,filedname=c.name,DefaultVal=d.text,DFname=oc.name FROM syscolumns c JOIN sysobjects ot on c.id=ot.id JOIN syscomments d on c.cdefault=d.id JOIN sysobjects oc on d.id=oc.id WHERE ot.name='test_table' AND c.name='test_column' EXEC(@s) go drop table test_table
test_column varchar(20) default 'aa'
)
go--删除默认
declare @s nvarchar(4000)
select @s=N'ALTER TABLE '+QUOTENAME(ot.name)
+N' DROP CONSTRAINT '+QUOTENAME(oc.name)
-- ,tbname=oc.name,filedname=c.name,DefaultVal=d.text,DFname=oc.name
FROM syscolumns c
JOIN sysobjects ot on c.id=ot.id
JOIN syscomments d on c.cdefault=d.id
JOIN sysobjects oc on d.id=oc.id
WHERE ot.name='test_table'
AND c.name='test_column'
EXEC(@s)
go
drop table test_table