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 vote268 views1 answer
How to count with except in psql
SQL
0 vote283 views2 answers
Starting mysql service from mac
SQL
9 votes276 views4 answers
How to remove duplicate in sql
SQL
0 vote278 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote312 views2 answers
Select last 30 days sql
SQL
0 vote480 views1 answer
The differnece between to values in sql
SQL
2 votes278 views2 answers
Select list is not in group by clause
SQL
1 vote279 views1 answer
Show table status command in mysql
SQL
0 vote267 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote291 views1 answer
Sql dmv to capture updates
SQL