|
use EnVisage
|
|
|
|
BEGIN TRANSACTION
|
|
GO
|
|
|
|
ALTER TABLE [dbo].[Team2Project] DROP CONSTRAINT [FK_Team2Project_Team]
|
|
GO
|
|
|
|
ALTER TABLE dbo.Team2Project ADD CONSTRAINT
|
|
FK_Team2Project_Team FOREIGN KEY
|
|
(
|
|
TeamId
|
|
) REFERENCES dbo.Team
|
|
(
|
|
Id
|
|
) ON UPDATE NO ACTION
|
|
ON DELETE CASCADE
|
|
|
|
GO
|
|
COMMIT
|