14 lines
405 B
Transact-SQL
14 lines
405 B
Transact-SQL
USE [EnVisage]
|
|
GO
|
|
|
|
if exists (select * from sys.all_columns where name like 'PerformanceGreenThreshold' and object_id = OBJECT_ID('Project'))
|
|
begin
|
|
alter table [Project]
|
|
drop column PerformanceGreenThreshold
|
|
end
|
|
|
|
if exists (select * from sys.all_columns where name like 'PerformanceGreenThreshold' and object_id = OBJECT_ID('Type'))
|
|
begin
|
|
alter table [Type]
|
|
drop column PerformanceGreenThreshold
|
|
end |