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 vote99 views3 answers
Sql count condition
SQL
1 vote117 views1 answer
Import sql file mysql commadn line
SQL
1 vote95 views1 answer
Index a database column sql
SQL
14 votes114 views4 answers
Sql compiler
SQL
0 vote138 views2 answers
Search stored procedures by name
SQL
0 vote115 views1 answer
Sql datediff month
SQL
4 votes104 views1 answer
Oracle show error line number
SQL
5 votes104 views2 answers
Oracle to_timestamp
SQL
2 votes103 views1 answer
Update with join sql server
SQL
3 votes108 views2 answers
Sql asc
SQL