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 vote385 views1 answer
Add super privilege mysql
SQL
17 votes380 views6 answers
Change column name in sql
SQL
0 vote353 views4 answers
Mysql on kubernetes
SQL
5 votes408 views2 answers
Add days in oracle sql
SQL
1 vote348 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote331 views1 answer
How to check if there is no database schema
SQL
2 votes366 views3 answers
Sql server: how to concatenate column data using comma
SQL
16 votes425 views2 answers
Sql vs nosql
SQL
1 vote360 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote346 views1 answer
Windows services sql
SQL