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

4 votes174 views1 answer
Data types in sql
SQL
1 vote191 views1 answer
Mysql select for update ejemplo
SQL
1 vote192 views1 answer
Sql set auto increment back to 0
SQL
3 votes213 views1 answer
Export postgres database linux
SQL
4 votes137 views1 answer
Oracle sleep
SQL
0 vote174 views1 answer
Sql trying to delete database in use
SQL
0 vote194 views2 answers
Mysql add days to date
SQL
0 vote265 views1 answer
Import sql dump into postgresql database
SQL
0 vote126 views1 answer
Sql truncate table referencing itself
SQL
4 votes203 views1 answer
Mysql set max connections
SQL