Postgresql delete cascade

CREATE TABLE employee(emp_id SERIAL PRIMARY  KEY, name VARCHAR(30),
	sector_fk INT NOT NULL);

CREATE TABLE process(emp_id SERIAL PRIMARY KEY, sector VARCHAR(20));

ALTER TABLE employee ADD FOREIGN KEY (sector_fk)
REFERENCES company(emp_id) ON DELETE CASCADE;

-- Deletes cascade employees referencing deleted companies
DELETE FROM company WHERE sector='industry';

Similar codes

0 vote309 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote301 views1 answer
Zsh: command not found: mysql mamp
SQL
1 vote474 views3 answers
Uninstall postgresql mac
SQL
0 vote313 views2 answers
Change database postgres
SQL
0 vote344 views1 answer
Sql date time query find
SQL
0 vote324 views1 answer
Oracle list subpartitions
SQL
0 vote338 views1 answer
Where date major today mysql
SQL
0 vote349 views1 answer
How to find symmetric pairs in sql
SQL
-2 votes312 views1 answer
Mysql not empty
SQL
3 votes303 views1 answer
Oracle detect invalid password
SQL