Tuesday 7 February 2017

add column if not exist in sql

IF not EXISTS (

SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'Employee') AND name = 'Name'


)
 

 
Begin
 
ALTER TABLE [Employee] ADD Name VARCHAR(200) NULL

end;

No comments:

Post a Comment