Ta bort från Child om Parent inte längre finns

SqlServer 2005

Ibland kan det bli så som nedan att Table1 rader tas bort, men Table2 rader bli kvar. Skulle då vilja ta bort de Table2 rader vars Table2.Table1Id inte längre har en relation till Table1.

Hur skulle detta går till?

CREATE TABLE [Table1] (
	[Id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
	[Quantity] [int] NOT NULL ,
	CONSTRAINT [PK_Table1] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [Table2] (
	[Id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
	[Table1Id] [int] NOT NULL ,
	[QuantityMinusValue] [int] NOT NULL ,
	CONSTRAINT [PK_Table2] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

INSERT INTO dbo.[Table1](Quantity) VALUES(9); //Id = 1

INSERT INTO dbo.[Table2](Table1Id, QuantityMinusValue) VALUES(1, 13);//Table1Id = 1
INSERT INTO dbo.[Table2](Table1Id, QuantityMinusValue) VALUES(18, 55);