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 vote304 views1 answer
Cahnge column name apex oracle
SQL
0 vote387 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
15 votes274 views4 answers
T-sql drop function if exists
SQL
0 vote264 views1 answer
Sql select column names starting with
SQL
0 vote280 views1 answer
Mssql view column data type
SQL
0 vote286 views1 answer
Sql developer connect to sql server
SQL
0 vote316 views1 answer
Stratified sampling sql
SQL
4 votes264 views2 answers
DB::transaction
SQL
0 vote280 views1 answer
How to add more columns to a table in mysql
SQL
0 vote291 views1 answer
Function plsql
SQL