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 vote108 views1 answer
Output to file mysql
SQL
0 vote113 views2 answers
Find lowest number in sql
SQL
1 vote122 views1 answer
Query for all indexes in table postgres
SQL
2 votes119 views1 answer
Sql server current date minus 5 years
SQL
0 vote106 views1 answer
INSERT INTO table using OpenQuery
SQL
2 votes119 views1 answer
Oracle insert or update
SQL
0 vote116 views1 answer
Date on SQL
SQL
0 vote170 views1 answer
Drop view sql
SQL
19 votes116 views2 answers
Mysql tinyint max value
SQL
0 vote137 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL