IF EXISTS (SELECT * FROM sys.objects WHERE object_id= OBJECT_ID(N'dbo.DimDate') AND type in (N'U'))
DROP TABLE dbo.DimDate;


IF EXISTS (SELECT * FROM sys.objects WHERE object_id= OBJECT_ID(N'dbo.DimLocation') AND type in (N'U'))
DROP TABLE dbo.DimLocation;

IF EXISTS (SELECT * FROM sys.objects WHERE object_id= OBJECT_ID(N'dbo.DimCustomer') AND type in (N'U'))
DROP TABLE dbo.DimCustomer;

IF EXISTS (SELECT * FROM sys.objects WHERE object_id= OBJECT_ID(N'dbo.DimProduct') AND type in (N'U'))
DROP TABLE dbo.DimProduct;

IF EXISTS (SELECT * FROM sys.objects WHERE object_id= OBJECT_ID(N'dbo.DimStore') AND type in (N'U'))
DROP TABLE dbo.DimStore;

IF EXISTS (SELECT * FROM sys.objects WHERE object_id= OBJECT_ID(N'dbo.DimPromotion') AND type in (N'U'))
DROP TABLE dbo.DimPromotion;


IF EXISTS (SELECT * FROM sys.objects WHERE object_id= OBJECT_ID(N'dbo.FactSales') AND type in (N'U'))
DROP TABLE dbo.FactSales;

IF EXISTS (SELECT * FROM sys.objects WHERE object_id= OBJECT_ID(N'dbo.FactSalesCustomer') AND type in (N'U'))
DROP TABLE dbo.FactSalesCustomer;