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 vote231 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
1 vote227 views1 answer
Pentaho + pasar de excel a sql
SQL
3 votes213 views1 answer
Sql replace character in string in all records
SQL
3 votes233 views2 answers
Sql asc
SQL
1 vote183 views1 answer
Mysql see column types
SQL
1 vote226 views1 answer
Multiple count in sql
SQL
0 vote238 views1 answer
Sql reverse order of results
SQL
0 vote227 views1 answer
Sql remove first character from string
SQL
0 vote235 views1 answer
Which lock mode is not available in sql
SQL
0 vote247 views2 answers
Port 5432 is already in use mac
SQL