Alter constraint postgres

/* Drop your constraint */
alter table yourtable drop constraint constraint_name;

/* Create new constraint */
alter table yourtable add constraint "constraint_name" FOREIGN KEY (some_id) REFERENCES yourtable(some_id) on delete cascade;

Similar codes

3 votes265 views1 answer
V$session not found in oracle
SQL
12 votes269 views1 answer
How to change the value of a table in sql
SQL
0 vote313 views1 answer
See the structure of a table mysql
SQL
0 vote304 views1 answer
Timestamp(0) postgresql
SQL
9 votes324 views3 answers
Sql delete where in
SQL
9 votes285 views1 answer
Sql server get utc date
SQL
0 vote273 views1 answer
Take sql dump in to file
SQL
0 vote299 views1 answer
Oracle exchange subpartition
SQL
3 votes289 views1 answer
Stpop start psql server
SQL
0 vote290 views4 answers
Mysql on kubernetes
SQL