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 vote169 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote232 views1 answer
Mysql show foreign keys column
SQL
0 vote227 views1 answer
Mysql faster delete
SQL
0 vote201 views1 answer
To Create directory
SQL
4 votes209 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote196 views1 answer
Sql order by except one row
SQL
0 vote183 views1 answer
Postgresql create query
SQL
0 vote184 views1 answer
Bidirectional outer join sql
SQL
1 vote187 views3 answers
Postgresql connect to database
SQL
6 votes175 views1 answer
Oracle list primary key
SQL