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 vote229 views1 answer
Median mysql
SQL
0 vote230 views2 answers
Insert into
SQL
0 vote233 views2 answers
Sql update top 100
SQL
4 votes241 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote254 views1 answer
.sql File Run in PSQL
SQL
6 votes231 views2 answers
Insert into select mysql
SQL
0 vote221 views1 answer
Setting default value for Boolean data type in SQL
SQL
7 votes307 views2 answers
Drop index oracle
SQL
24 votes199 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote238 views1 answer
Java spring boot connect to sql server
SQL