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

4 votes145 views1 answer
Wilayah indonesia sql
SQL
0 vote145 views1 answer
Ajax error exception handeling
SQL
0 vote102 views1 answer
Online sql compiler
SQL
0 vote197 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote158 views1 answer
Mysql row generator
SQL
1 vote135 views1 answer
Store select query result in variable sql server
SQL
0 vote138 views1 answer
Show the colums of table sql
SQL
1 vote154 views1 answer
Mysql order by desc null last
SQL
2 votes140 views2 answers
Oracle multiple insert
SQL
0 vote161 views2 answers
Sql stored procedure for access frontend
SQL