155 lines
20 KiB
Plaintext
155 lines
20 KiB
Plaintext
DECLARE @ObjectName NVARCHAR(100)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigOn';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigOnX';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigOnY';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigOnZ';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigOn';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigOnX';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigOnY';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigOnZ';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigOn';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigOnX';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigOnY';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigOnZ';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigOn';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigOnX';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigOnY';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigOnZ';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigX';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigY';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'LowgLVLTrigZ';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigX';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigY';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HighgLVLTrigZ';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigX';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigY';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'AngAccelLVLTrigZ';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigX';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigY';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'ARSLVLTrigZ';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HumidityLVLTrigOn';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'PressureLVLTrigOn';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'TemperatureLVLTrigOn';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HumidityLVLTrigBelow';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'HumidityLVLTrigAbove';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'PressureLVLTrigBelow';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'PressureLVLTrigAbove';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'TemperatureLVLTrigBelow';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
SELECT @ObjectName = OBJECT_NAME([default_object_id]) FROM SYS.COLUMNS
|
|
WHERE [object_id] = OBJECT_ID('[dbo].[TestSetups]') AND [name] = 'TemperatureLVLTrigAbove';
|
|
IF (@ObjectName IS NOT NULL) EXEC('ALTER TABLE [dbo].[TestSetups] DROP CONSTRAINT ' + @ObjectName)
|
|
|
|
ALTER TABLE dbo.TestSetups
|
|
DROP COLUMN LowgLVLTrigOn, LowgLVLTrigOnX, LowgLVLTrigOnY, LowgLVLTrigOnZ, HighgLVLTrigOn, HighgLVLTrigOnX, HighgLVLTrigOnY, HighgLVLTrigOnZ, AngAccelLVLTrigOn, AngAccelLVLTrigOnX, AngAccelLVLTrigOnY, AngAccelLVLTrigOnZ, ARSLVLTrigOn, ARSLVLTrigOnX, ARSLVLTrigOnY, ARSLVLTrigOnZ, LowgLVLTrigX, LowgLVLTrigY, LowgLVLTrigZ, HighgLVLTrigX, HighgLVLTrigY, HighgLVLTrigZ, AngAccelLVLTrigX, AngAccelLVLTrigY, AngAccelLVLTrigZ, ARSLVLTrigX, ARSLVLTrigY, ARSLVLTrigZ, HumidityLVLTrigOn, PressureLVLTrigOn, TemperatureLVLTrigOn, HumidityLVLTrigBelow, HumidityLVLTrigAbove, PressureLVLTrigBelow, PressureLVLTrigAbove, TemperatureLVLTrigBelow, TemperatureLVLTrigAbove
|
|
|
|
ALTER TABLE dbo.TestSetups SET (LOCK_ESCALATION = TABLE)
|