11 lines
336 B
Transact-SQL
11 lines
336 B
Transact-SQL
USE [EnVisage]
|
|
GO
|
|
if exists(select * from sys.columns
|
|
where Name = N'Weekends' and Object_ID = Object_ID(N'Training'))
|
|
begin
|
|
alter table Training drop column Weekends
|
|
end
|
|
|
|
alter table Training add Weekends nvarchar(256)
|
|
update Training set Weekends = ''
|
|
alter table Training alter column Weekends nvarchar(256) not null |