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 vote195 views1 answer
Check if has alpha characters sql
SQL
1 vote191 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote261 views1 answer
Restart serial number for postgres
SQL
0 vote183 views1 answer
Show create table in postgresql
SQL
0 vote189 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote190 views1 answer
Timestamp(0) postgresql
SQL
1 vote208 views2 answers
Mysql extract number from string
SQL
5 votes220 views1 answer
How to use rank function in sql
SQL
0 vote252 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote208 views1 answer
Mysql dump with table query
SQL