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 vote134 views1 answer
Longtext sql
SQL
0 vote140 views1 answer
Check if database exists sql
SQL
0 vote132 views1 answer
How to use sqlcommand
SQL
0 vote137 views1 answer
Get substract count sql
SQL
15 votes138 views6 answers
Psql
SQL
0 vote134 views1 answer
Compare subqueries oracle
SQL
1 vote130 views3 answers
Getdate function in postgresql
SQL
0 vote157 views1 answer
Where field is null sql knex
SQL
0 vote130 views1 answer
Sqlite explain plan
SQL
0 vote135 views2 answers
Postgres show current role
SQL