drop table sql cascade code example

Example 1: drop cascade

drop table if exists table_name cascade;

Example 2: sql cascade delete sql

ALTER TABLE dbo.T2
   DROP CONSTRAINT FK_T1_T2   -- or whatever it's called

ALTER TABLE dbo.T2
   ADD CONSTRAINT FK_T1_T2_Cascade
   FOREIGN KEY (EmployeeID) REFERENCES dbo.T1(EmployeeID) ON DELETE CASCADE

Tags:

Sql Example

Related