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 vote100 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote119 views1 answer
Sql alternative to max statement
SQL
-1 vote117 views1 answer
Ssql to lowercqse
SQL
0 vote117 views1 answer
Sql get user account
SQL
0 vote124 views1 answer
Enable sql server full text indexing
SQL
0 vote121 views1 answer
Sql dmv to capture updates
SQL
19 votes120 views6 answers
What is mySQL
SQL
1 vote142 views1 answer
Oracle grant select on schema
SQL
12 votes129 views6 answers
Select distinct
SQL
8 votes118 views1 answer
Oracle add months to sysdate
SQL