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 vote359 views1 answer
List all functions and procedures in postgres query
SQL
0 vote458 views1 answer
Stop and start mysql
SQL
1 vote387 views2 answers
Extract weekday from date in sql
SQL
11 votes426 views1 answer
Oracle insert from select
SQL
0 vote346 views1 answer
Where in clause tsql
SQL
0 vote367 views1 answer
Mysql subdate
SQL
4 votes456 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote351 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
3 votes375 views4 answers
Order by desc postgres
SQL
0 vote385 views1 answer
Create table like sql
SQL