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 vote263 views1 answer
Sql into vs insert into
SQL
2 votes284 views1 answer
Where clause for child record apex
SQL
-1 vote288 views1 answer
Create view in mysql workbench
SQL
1 vote271 views1 answer
Sql dcl
SQL
0 vote313 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote282 views3 answers
How to run sql query
SQL
0 vote264 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote273 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
3 votes259 views2 answers
Plsql print
SQL
0 vote264 views1 answer
Utiliser sql ligne de commande
SQL