Tech Notes:

SQL Server Scripts:

OPSROOT

N/A - No scripts run.  Version simply updated to 774.

FACILITY DATABASES

ALTER TABLE [SETTINGS] ALTER COLUMN [CURVALUE] NVARCHAR(250)

Find the constraint to drop:

SELECT obj_table.NAME AS TableName, obj_Constraint.NAME AS ConstraintName, columns.NAME AS ColumnName
FROM sys.objects obj_table JOIN sys.objects obj_Constraint ON obj_table.object_id = obj_Constraint.parent_object_id
JOIN sys.sysconstraints constraints ON constraints.constid = obj_Constraint.object_id
JOIN sys.columns columns ON columns.object_id = obj_table.object_id AND columns.column_id = constraints.colid
WHERE obj_table.NAME = 'LC_TEST' AND columns.NAME='RL'

 ALTER TABLE LC_TEST DROP CONSTRAINT ConstraintNameReturnedFromQuery            'DF__LC_TEST__RL__45DE573A
 SP_RENAME 'LC_TEST.RL','RLBAD','COLUMN'")
 ALTER TABLE LC_TEST ADD RL FLOAT NULL DEFAULT (NULL)")
 UPDATE LC_TEST SET RL=RLBAD")
 ALTER TABLE LC_TEST DROP COLUMN RLBAD")
          

 

ORACLE:

OPSROOT

N/A - No scripts run.  Version simply updated to 774.

FACILITY DATABASES

N/A - No scripts run.  Version simply updated to 774.