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 vote376 views2 answers
SQL FROM
SQL
0 vote337 views2 answers
Sqlite
SQL
2 votes327 views1 answer
Convert series number to date in sql
SQL
3 votes365 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
1 vote323 views1 answer
Truncate table in postgresql and reset id
SQL
6 votes349 views1 answer
Check Table Exists
SQL
0 vote362 views1 answer
Sql convert datetime to year
SQL
0 vote337 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
1 vote331 views1 answer
Mysql find tables with column name
SQL
4 votes345 views3 answers
Mysql modify foreign key
SQL