May I have an assistance on CREATE TABLE Command

 

Hello Mambers of PGSQL-SQL,

 

I have two tables namely:

 

    REGION (region_id, region_name)

    DISTRICT (dist_id, dist_name, region_id (FK))

 

I would like to have the CREATE TABLE Command which will create these tables in such a way that when REGION table is UPDATED automatical the FOREGN KEY in DISTRICT  table is also updated.

 

I will appriciate for your assistance !

Regards

 

James Kitambara