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 vote157 views1 answer
Load data infile mariadb slow
SQL
0 vote131 views1 answer
Learn sqlite dart
SQL
0 vote139 views1 answer
Select the date 30 days less that the todays date sql request
SQL
13 votes151 views2 answers
Sql join 3 tables
SQL
0 vote151 views1 answer
Mysql dump for selected row
SQL
0 vote143 views1 answer
Sqlite3_open_v2
SQL
5 votes147 views4 answers
Upload database mysql command line
SQL
0 vote167 views1 answer
Python mysql executemany
SQL
0 vote164 views1 answer
Multiple like values for single column postgres
SQL
0 vote150 views1 answer
Oracle chain step succeeded
SQL