Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to add on delete cascade to existing table column postgres

alter table public.scores
drop constraint scores_gid_fkey,
add constraint scores_gid_fkey
   foreign key (gid)
   references games(gid)
   on delete cascade;
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #add #delete #cascade #existing #table #column #postgres
ADD COMMENT
Topic
Name
9+4 =