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

9 votes157 views2 answers
Convert data type in sql
SQL
0 vote143 views1 answer
List all permissions on a table in postgres
SQL
1 vote145 views1 answer
Psql lst trigger
SQL
0 vote145 views1 answer
Mysql create index lost connection
SQL
0 vote147 views1 answer
Apt install sql server
SQL
1 vote144 views1 answer
Access the postgres psql
SQL
1 vote143 views1 answer
Sometimes i cant edit sql developer
SQL
3 votes150 views1 answer
Fk in insert mysql
SQL
14 votes145 views2 answers
Sql cast
SQL
0 vote139 views1 answer
Monthly Birthday SQL Query
SQL