EnVisageOnline/Main/Database/Scripts/20151014/03_remove_unused_tables.sql

26 lines
377 B
Transact-SQL

USE EnVisage
GO
IF OBJECT_ID('Scenario_Snapshot') IS NOT NULL
BEGIN
DROP TABLE Scenario_Snapshot
END
GO
IF OBJECT_ID('Scenario_Wide') IS NOT NULL
BEGIN
DROP TABLE Scenario_Wide
END
GO
IF OBJECT_ID('View2CostCenter') IS NOT NULL
BEGIN
DROP TABLE View2CostCenter
END
GO
IF OBJECT_ID('User2ExpenditureCategory') IS NOT NULL
BEGIN
DROP TABLE User2ExpenditureCategory
END
GO