1ALTER TABLE dbo.T2
2 DROP CONSTRAINT FK_T1_T2 -- or whatever it's called
3
4ALTER TABLE dbo.T2
5 ADD CONSTRAINT FK_T1_T2_Cascade
6 FOREIGN KEY (EmployeeID) REFERENCES dbo.T1(EmployeeID) ON DELETE CASCADE
7
1CREATE TABLE child_table
2(
3 column1 datatype [ NULL | NOT NULL ],
4 column2 datatype [ NULL | NOT NULL ],
5 ...
6
7 CONSTRAINT fk_name
8 FOREIGN KEY (child_col1, child_col2, ... child_col_n)
9 REFERENCES parent_table (parent_col1, parent_col2, ... parent_col_n)
10 ON DELETE CASCADE
11 [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ]
12);