Drop a column with a default constraint in SQL Server (IF EXISTS)

Viewed 73866

I am writing a sql script for dropping column and a default constraint. The following script works fine but i like to know if it is a right way of doing it.

Can i drop a default constraint with a column in one statement instead of using two separate ones?

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Employees_EmpID]') AND type = 'D')

BEGIN    
   ALTER TABLE [dbo].[Employees] DROP CONSTRAINT [DF_Employees_EmpID]    
END    
GO    
BEGIN   
  ALTER TABLE [dbo].[Employees] DROP COLUMN [EmpID]    
END
4 Answers
Related