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 vote342 views1 answer
Incorrect string value: mysql
SQL
3 votes353 views1 answer
Create a table with an id in mysql
SQL
4 votes284 views3 answers
Create table if not exists postgresql
SQL
0 vote345 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote344 views1 answer
How to find table lock and row lock in mysql
SQL
7 votes349 views5 answers
Sql remove spaces
SQL
3 votes308 views1 answer
Sql several or
SQL
0 vote332 views1 answer
Mysql timediff
SQL
0 vote291 views1 answer
Print sum of values sql
SQL
-3 votes357 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL