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 vote297 views1 answer
R2dbc-postgresqldriver dependency
SQL
1 vote347 views1 answer
Sql select row with max date
SQL
2 votes289 views1 answer
Update trigger
SQL
22 votes289 views4 answers
Tsql rename table
SQL
1 vote348 views1 answer
Import sql file from laravel
SQL
17 votes269 views2 answers
How to assign date field for table in mysql
SQL
0 vote319 views2 answers
How to prevent sql injection in java
SQL
3 votes289 views1 answer
Oracle revoke
SQL
5 votes321 views1 answer
Sql table columns
SQL
10 votes312 views2 answers
Select nextval from sequence oracle
SQL