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

2 votes177 views1 answer
Sql update alias
SQL
0 vote178 views1 answer
Cast for print sql
SQL
13 votes213 views2 answers
Oracle inner join
SQL
0 vote191 views1 answer
Cannot pip install mysqlclient
SQL
0 vote239 views1 answer
Google sheets data validation custom formula filter
SQL
2 votes197 views1 answer
Sql server check for value in multiple columns
SQL
33 votes174 views2 answers
Postgres how to add field created at
SQL
0 vote178 views1 answer
Sql server manager close connection
SQL
-1 vote233 views4 answers
Sql view postgresql
SQL
2 votes187 views4 answers
Check timezone of mysql database
SQL