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 vote138 views1 answer
How to connect pgadmin with excel
SQL
0 vote165 views1 answer
Automated psql csv export script on windows
SQL
0 vote151 views1 answer
How to query all tables mysql at the same time
SQL
2 votes163 views2 answers
Mysql on duplicate key update get value from values
SQL
1 vote155 views1 answer
Sample in sql
SQL
0 vote162 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote139 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote175 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
1 vote142 views1 answer
Data type and their numeric form
SQL
1 vote153 views1 answer
Altrer name column postgres
SQL