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 vote259 views2 answers
Create new table from existing table with data in sql server
SQL
13 votes154 views2 answers
Oracle inner join
SQL
0 vote158 views2 answers
How to install psql in ubuntu
SQL
0 vote138 views1 answer
Mssql dockere
SQL
0 vote125 views2 answers
Sql day from datetime
SQL
0 vote126 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote146 views1 answer
Mysql utc timestamp
SQL
1 vote125 views1 answer
Mysql login console
SQL
8 votes124 views3 answers
Alter table auto_increment
SQL
1 vote123 views1 answer
Mysql best tutorial for beginners
SQL