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 vote190 views1 answer
Sql clear table
SQL
2 votes189 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote198 views5 answers
Mode sql course
SQL
0 vote189 views1 answer
Android sqlite add column if not exists
SQL
14 votes189 views2 answers
How to auto increment in sql
SQL
0 vote244 views1 answer
Intellij mysql set timezone
SQL
3 votes184 views1 answer
Sql server check version
SQL
1 vote190 views1 answer
Float precision in psql
SQL
2 votes187 views1 answer
How to find constraints on a table in oracle
SQL
0 vote186 views1 answer
C# add a textbox in mysql select
SQL