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

24 votes233 views4 answers
Delete db postgres
SQL
0 vote232 views1 answer
Check command
SQL
1 vote201 views2 answers
Mssql show database size
SQL
56 votes602 views5 answers
Psql create user
SQL
0 vote223 views1 answer
Edit shchima table in sql
SQL
0 vote239 views10 answers
Sql statement checker corrector
SQL
0 vote196 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
2 votes240 views1 answer
Username sql
SQL
2 votes193 views1 answer
Get first n letter of department name in sql
SQL
0 vote250 views1 answer
Check database restore status sql script
SQL