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 vote314 views2 answers
Sql join on comma separated field
SQL
1 vote331 views2 answers
Postgresql truncate cascade restart identity
SQL
3 votes406 views1 answer
Oracle nextval insert
SQL
0 vote311 views1 answer
Call procedure in wordpress
SQL
5 votes311 views3 answers
Mysql extract month from date
SQL
0 vote305 views1 answer
Limit and offset in stored procedure mssql
SQL
8 votes349 views2 answers
Between operator
SQL
1 vote315 views1 answer
How to use a trigger to validate input data
SQL
17 votes315 views3 answers
Postgresql version command
SQL
0 vote265 views1 answer
Sql count how many times a value appears
SQL