Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF NOT EXISTS(SELECT 1 FROM sys.columns
- WHERE Name = N'Pred2015'
- AND Object_ID = Object_ID(N'schemaName.PF_TT_FoodGroup_Coffee'))
- BEGIN
- ALTER TABLE PF_TT_FoodGroup_Coffee
- ADD Pred2015 float;
- END
- IF NOT EXISTS(SELECT 1 FROM sys.columns
- WHERE Name = N'Pred2016'
- AND Object_ID = Object_ID(N'schemaName.PF_TT_FoodGroup_Coffee'))
- BEGIN
- ALTER TABLE PF_TT_FoodGroup_Coffee
- ADD Pred2016 float;
- END
- IF NOT EXISTS(SELECT 1 FROM sys.columns
- WHERE Name = N'Pred2017'
- AND Object_ID = Object_ID(N'schemaName.PF_TT_FoodGroup_Coffee'))
- BEGIN
- ALTER TABLE PF_TT_FoodGroup_Coffee
- ADD Pred2017 float;
- END
- IF NOT EXISTS(SELECT 1 FROM sys.columns
- WHERE Name = N'Pred2018'
- AND Object_ID = Object_ID(N'schemaName.PF_TT_FoodGroup_Coffee'))
- BEGIN
- ALTER TABLE PF_TT_FoodGroup_Coffee
- ADD Pred2018 float;
- END
- IF NOT EXISTS(SELECT 1 FROM sys.columns
- WHERE Name = N'Pred2019'
- AND Object_ID = Object_ID(N'schemaName.PF_TT_FoodGroup_Coffee'))
- BEGIN
- ALTER TABLE PF_TT_FoodGroup_Coffee
- ADD Pred2019 float;
- END
- IF NOT EXISTS(SELECT 1 FROM sys.columns
- WHERE Name = N'Pred2020'
- AND Object_ID = Object_ID(N'schemaName.PF_TT_FoodGroup_Coffee'))
- BEGIN
- ALTER TABLE PF_TT_FoodGroup_Coffee
- ADD Pred2020 float;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement