Hello,I have the following tables:create table dbo.Documents( Id int identity not null, Created datetime not null, [File] varbinary(max) filestream constraint DF_Documents_File default(0x), Updated datetime not null, constraint PK_Documents primary key clustered(Id)) -- Documentscreate table dbo.DocumentsPages( DocumentId int not null, PageId int not null, constraint PK_DocumentsPages primary key clustered(DocumentId,PageId)) -- DocumentsPagescreate table dbo.Pages( Id int identity not null, Number int not null, [Key] uniqueidentifier not null rowguidcol constraint U_Pages_Keyunique, [File] varbinary(max) filestream constraint DF_Pages_File default(0x), constraint PK_Pages primary key clustered(Id)) -- PagesAnd the following relationships:alter table dbo.DocumentsPagesadd constraint FK_DocumentsPages_Documents foreign key (DocumentId)references Documents(Id) on delete cascade on update cascade, constraint FK_DocumentsPages_Pages foreign key (PageId) referencesPages(Id) on delete cascade on update cascade;
When I delete a Document its DocumentsPages are deleted but the Pagesrecords not.What am I missing?Thanks,Miguel