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 vote225 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote226 views1 answer
Mariadb disable foreign key checks
SQL
0 vote213 views1 answer
Postgres jsonb array push new element
SQL
0 vote221 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote228 views2 answers
Alter table add multiple columns mysql
SQL
0 vote227 views1 answer
Mysql where in maintain order
SQL
0 vote221 views3 answers
Database restoring error
SQL
11 votes236 views5 answers
Laravel db facade
SQL
1 vote224 views3 answers
Date_add mysql
SQL
11 votes219 views3 answers
Change column name sql server management studio
SQL