25 lines
666 B
Transact-SQL
25 lines
666 B
Transact-SQL
use [envisage]
|
|
|
|
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
|
|
BEGIN TRANSACTION
|
|
SET QUOTED_IDENTIFIER ON
|
|
SET ARITHABORT ON
|
|
SET NUMERIC_ROUNDABORT OFF
|
|
SET CONCAT_NULL_YIELDS_NULL ON
|
|
SET ANSI_NULLS ON
|
|
SET ANSI_PADDING ON
|
|
SET ANSI_WARNINGS ON
|
|
COMMIT
|
|
BEGIN TRANSACTION
|
|
GO
|
|
ALTER TABLE dbo.Scenario_Detail ADD CONSTRAINT
|
|
PK_Scenario_Detail PRIMARY KEY CLUSTERED
|
|
(
|
|
Id
|
|
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
|
GO
|
|
ALTER TABLE dbo.Scenario_Detail SET (LOCK_ESCALATION = TABLE)
|
|
GO
|
|
COMMIT
|