22 lines
589 B
Transact-SQL
22 lines
589 B
Transact-SQL
|
|
USE [envisage]
|
|
GO
|
|
|
|
EXECUTE sp_rename N'dbo.ScenarioCln.SystemAttributeObjectID', N'Tmp_SystemAttributeObjectID', 'COLUMN'
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[ScenarioCln] ADD [SystemAttributeObjectID] [uniqueidentifier] NULL
|
|
GO
|
|
|
|
UPDATE [dbo].[ScenarioCln]
|
|
SET [SystemAttributeObjectID] = '9371A4AC-696A-4E4C-9809-94919892D342'
|
|
WHERE [Tmp_SystemAttributeObjectID] = 5017155
|
|
|
|
UPDATE [dbo].[ScenarioCln]
|
|
SET [SystemAttributeObjectID] = '38323EB1-CB2F-4EF0-890A-A418C5E088B7'
|
|
WHERE [Tmp_SystemAttributeObjectID] = 5017156
|
|
|
|
ALTER TABLE [dbo].[ScenarioCln]
|
|
DROP COLUMN [Tmp_SystemAttributeObjectID]
|
|
GO
|