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

2 votes248 views2 answers
Mysql compare datetime to another datetime
SQL
8 votes241 views1 answer
Oracle search code in packages
SQL
0 vote174 views1 answer
Create user faunadb
SQL
1 vote186 views1 answer
Psql human readable
SQL
0 vote173 views1 answer
Increase speed of like queries postgres
SQL
1 vote166 views1 answer
Sql eliminare un record
SQL
0 vote168 views1 answer
Find invalid datetime field
SQL
4 votes179 views1 answer
For loop postgresql
SQL
1 vote177 views1 answer
Sql how to replace full stop
SQL
14 votes250 views1 answer
How to export db from mysql
SQL