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

2 votes197 views1 answer
SELECT INTO
SQL
1 vote205 views1 answer
Mysql show queries running
SQL
0 vote213 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote206 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
-1 vote328 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote266 views3 answers
Sql parenthetical expression examples
SQL
0 vote210 views1 answer
Datatables server side filter where clause
SQL
19 votes204 views3 answers
How to change column type psql
SQL
5 votes199 views2 answers
Sql create tabel with primary key auto_increment code
SQL
1 vote201 views1 answer
Mariadb alter user host
SQL