36 lines
1.5 KiB
Transact-SQL
36 lines
1.5 KiB
Transact-SQL
USE [EnVisage]
|
||
GO
|
||
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.PeopleResourceActuals
|
||
DROP CONSTRAINT FK_PeopleResourceActuals_PeopleResource
|
||
GO
|
||
ALTER TABLE dbo.PeopleResource SET (LOCK_ESCALATION = TABLE)
|
||
GO
|
||
COMMIT
|
||
BEGIN TRANSACTION
|
||
GO
|
||
ALTER TABLE dbo.PeopleResourceActuals ADD CONSTRAINT
|
||
FK_PeopleResourceActuals_PeopleResource FOREIGN KEY
|
||
(
|
||
PeopleResourceId
|
||
) REFERENCES dbo.PeopleResource
|
||
(
|
||
Id
|
||
) ON UPDATE NO ACTION
|
||
ON DELETE CASCADE
|
||
|
||
GO
|
||
ALTER TABLE dbo.PeopleResourceActuals SET (LOCK_ESCALATION = TABLE)
|
||
GO
|
||
COMMIT
|