Cascade delete behavior for FK between PKs in TPT

[smitpatel]

Test Delete_where_using_hierarchy fails.
It is trying to delete entity which has dependent containing TPT. The failure indicates that cascade delete in TPT failed. Looking at database schema the FK doesn't contain cascade delete behavior.

USE [TPTInheritanceTest]
GO

/****** Object:  Table [dbo].[Birds]    Script Date: 7/28/2022 10:18:42 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Birds](
	[Species] [nvarchar](100) NOT NULL,
	[IsFlightless] [bit] NOT NULL,
	[EagleId] [nvarchar](100) NULL,
 CONSTRAINT [PK_Birds] PRIMARY KEY CLUSTERED 
(
	[Species] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Birds]  WITH CHECK ADD  CONSTRAINT [FK_Birds_Animals_Species] FOREIGN KEY([Species])
REFERENCES [dbo].[Animals] ([Species])
GO

ALTER TABLE [dbo].[Birds] CHECK CONSTRAINT [FK_Birds_Animals_Species]
GO

ALTER TABLE [dbo].[Birds]  WITH CHECK ADD  CONSTRAINT [FK_Birds_Eagle_EagleId] FOREIGN KEY([EagleId])
REFERENCES [dbo].[Eagle] ([Species])
GO

ALTER TABLE [dbo].[Birds] CHECK CONSTRAINT [FK_Birds_Eagle_EagleId]
GO

[ajcvickers]

Poaching