21 lines
580 B
Transact-SQL
21 lines
580 B
Transact-SQL
USE [envisage]
|
|
GO
|
|
|
|
EXECUTE sp_rename N'dbo.Expenditure_Category.SystemAttributeOne', N'Tmp_SystemAttributeOne', 'COLUMN'
|
|
GO
|
|
EXECUTE sp_rename N'dbo.Expenditure_Category.SystemAttributeTwo', N'Tmp_SystemAttributeTwo', 'COLUMN'
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[Expenditure_Category] ADD [SystemAttributeOne] [uniqueidentifier] NULL
|
|
ALTER TABLE [dbo].[Expenditure_Category] ADD [SystemAttributeTwo] [uniqueidentifier] NULL
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[Expenditure_Category]
|
|
DROP COLUMN [Tmp_SystemAttributeOne]
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[Expenditure_Category]
|
|
DROP COLUMN [Tmp_SystemAttributeTwo]
|
|
GO
|
|
|