use envisage2
go

delete from Rate
go
delete from Scenario_Detail
go
delete from ProjectAccess
go
delete from Fee_Calculation
go
delete from Expenditure2Expenditure
go
delete from Expenditure_Category
go
delete from Expenditure
go
delete from Scenario
go
delete from Project
go


begin tran
if exists (select * from sys.all_columns where name like 'FactorInt' and object_id like OBJECT_ID('[Expenditure2Expenditure]'))
begin
ALTER TABLE [Expenditure2Expenditure] DROP COLUMN FactorInt
ALTER TABLE [Expenditure2Expenditure] Add FactorInt decimal(6,3) null
end
commit tran