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 vote179 views1 answer
Sql alter table order by
SQL
0 vote194 views2 answers
Sql having multiple conditions
SQL
0 vote178 views4 answers
How to get max salary in each department in sql
SQL
0 vote192 views1 answer
Mysql edit trigger
SQL
0 vote221 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote181 views1 answer
Mysql where in maintain order
SQL
0 vote168 views1 answer
Get the First and Last Word from a String or Sentence
SQL
5 votes157 views3 answers
How to remove unique key constraint in mysql
SQL
19 votes175 views6 answers
Sql server drop table if exists
SQL
0 vote167 views1 answer
Soql more than today
SQL