EnVisageOnline/Main/Database/Scripts/20151230/02_drop_training_columns.sql

10 lines
206 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, PercentAllocated
END