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 vote231 views1 answer
Oracle plan hash value
SQL
3 votes207 views1 answer
Ssh check mysql version
SQL
4 votes212 views2 answers
SELECT table_name FROM user_tables;
SQL
4 votes211 views4 answers
Rollback in sql
SQL
0 vote222 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
1 vote196 views1 answer
Psql connections
SQL
3 votes215 views1 answer
Oracle list user grants
SQL
0 vote190 views1 answer
Change default schema sql server
SQL
10 votes207 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote215 views1 answer
Sql change primary key to composite key
SQL