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

0 vote155 views1 answer
Sqlite version check
SQL
0 vote143 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote139 views1 answer
Mysql in clausule string array
SQL
0 vote140 views1 answer
Sql contains vs like
SQL
5 votes139 views1 answer
Find table from column name in sql
SQL
3 votes145 views3 answers
Docker create postgresql database
SQL
4 votes172 views1 answer
Alter session set nls_date_format
SQL
0 vote160 views2 answers
PostgreSQL having
SQL
4 votes101 views1 answer
Oracle sleep
SQL
4 votes137 views1 answer
Restart for pg_hba.conf file
SQL