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

2 votes252 views1 answer
Import large .sql files into lampp
SQL
0 vote246 views1 answer
Mysql into outfile with headers
SQL
0 vote269 views1 answer
Sql log file inof
SQL
16 votes259 views1 answer
Sql comment'
SQL
32 votes302 views6 answers
Rename column mysql
SQL
3 votes277 views1 answer
APEX elapsed time
SQL
2 votes271 views1 answer
Sql server case sensitive search
SQL
0 vote239 views1 answer
Selects all the columns from the sailors table
SQL
3 votes260 views2 answers
Mysql user permission database
SQL
1 vote247 views1 answer
Add time to date sql
SQL