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 vote145 views1 answer
How to get button for every record from mysql
SQL
0 vote144 views4 answers
Rownum in sql
SQL
0 vote124 views9 answers
Linq to sql converter online
SQL
0 vote168 views1 answer
Cahnge column name apex oracle
SQL
0 vote114 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote82 views1 answer
How to connect sql server using ip address in c#
SQL
1 vote145 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote127 views1 answer
Column ' ' in field list is ambiguous
SQL
12 votes128 views1 answer
Psql drop column
SQL
0 vote137 views2 answers
Mysql missin expression near on
SQL