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

22 votes292 views2 answers
Mysql show all tables
SQL
0 vote300 views1 answer
Mysql table variables
SQL
1 vote292 views2 answers
Postgresql backup and restore globals and data
SQL
6 votes306 views1 answer
Wordpress change user password sql
SQL
0 vote311 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote311 views1 answer
Ver usuarios mysql
SQL
7 votes312 views3 answers
How ot change name of column mysql
SQL
1 vote357 views1 answer
Delete dublicate rows sql
SQL
16 votes327 views6 answers
Python sqlite
SQL
0 vote323 views2 answers
While mysql
SQL