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

4 votes174 views3 answers
NOT NULL SQL
SQL
0 vote149 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote154 views1 answer
Postgres concat_ws
SQL
2 votes187 views1 answer
Mysql shell insert into
SQL
1 vote156 views5 answers
Postgresql difference between two dates in days
SQL
1 vote159 views1 answer
Oracle nvl2
SQL
1 vote139 views1 answer
Select dba users oracle
SQL
1 vote166 views1 answer
Mysql order by desc null last
SQL
0 vote151 views1 answer
Check if string is a number sql
SQL
10 votes145 views1 answer
Create table oracle
SQL