155 lines
20 KiB
Transact-SQL
155 lines
20 KiB
Transact-SQL
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)
|