删除MSSQL2005里的默认值

这个只针对MSSQL2005,2008

 

if exists (select 1 from sysobjects where  id = object_id('PD_Debug_DropDefault') and type in ('P','PC'))
   drop procedure PD_Debug_DropDefault
go

create procedure PD_Debug_DropDefault
(
 @object_name nvarchar(100),
 @column_name nvarchar(100)
)
as
begin
 declare @dfName nvarchar(100)
 select @dfName=name from sys.default_constraints c
 where parent_object_id=object_id(@object_name) and
  parent_column_id=(
   select column_id from sys.columns
   where object_id=object_id(@object_name) and name=@column_name)
 if @dfName is not null
 begin
  exec (N'alter table ' + @object_name + ' drop constraint '+@dfName)
 end
end