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

6 votes154 views2 answers
How to get last element sql
SQL
7 votes101 views1 answer
Append column sql
SQL
4 votes94 views3 answers
Mysql varchar length
SQL
0 vote115 views1 answer
Sql select inside select sub query
SQL
0 vote111 views1 answer
Import Data in MySQL without using any other software
SQL
1 vote120 views1 answer
Sqlite3 read only
SQL
0 vote102 views1 answer
Print intervals of 15 minutes in sql query
SQL
1 vote103 views1 answer
Mysql get max value and id
SQL
18 votes97 views3 answers
Mysql add column with default value
SQL
5 votes94 views1 answer
Sql first day of current year
SQL