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

-1 vote163 views3 answers
Psql get last rows
SQL
1 vote150 views1 answer
Sql auto date
SQL
0 vote166 views1 answer
Mysql not defined
SQL
0 vote231 views1 answer
Sqlite display headers on columns
SQL
0 vote163 views1 answer
Add unique constraint sql server multiple columns
SQL
20 votes159 views3 answers
SQL query rename table
SQL
0 vote206 views1 answer
Plpgsql create function
SQL
1 vote154 views2 answers
Mysql filter by date mount
SQL
21 votes218 views6 answers
Update sql
SQL
0 vote156 views1 answer
Uncomment listen_address=localhost
SQL