Hello,I have the following constraint:alter table dbo.Devicesadd constraint Devices_ModelId_FK foreign key(ModelId) references dbo.Models(Id) on delete cascade on update cascade,
On table devices:create table dbo.Devices( Id int identity not null constraint Devices_Id_PK primary key clustered (Id), ModelId int not null, [Serial] nvarchar (120) not null constraint Devices_Used_DF default (0))
So my interpretation is when a Device is deleted the Model is deleted. So I should change the Delete Cascade to no action. Correct?And what about update cascade. In my case I will never change the Id of Devices so having update cascade or no action will be the same. Correct?What is the correct approach for this?Thank You,Miguel
On Delete Cascade and On Delete Update
Posted - 2011-02-03 : 12:32:03
