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 vote398 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote367 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
2 votes345 views1 answer
Query to find table size in oracle 12c
SQL
0 vote374 views1 answer
Mysql order by rand limit 1 really slow
SQL
1 vote365 views1 answer
Mysql last year
SQL
2 votes348 views2 answers
Postgres drop column if exists
SQL
5 votes345 views4 answers
Select random rows sql
SQL
1 vote357 views1 answer
Oracle difference between two dates in years
SQL
0 vote326 views1 answer
Bigquery declare
SQL
12 votes344 views4 answers
Import mysql database command line linux
SQL