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 votes219 views3 answers
Order by postgres
SQL
0 vote221 views1 answer
Check command
SQL
1 vote175 views2 answers
Mysql order by date asc null last
SQL
1 vote193 views1 answer
Get create table query existing table mysql
SQL
1 vote236 views1 answer
Sample clause in sql
SQL
2 votes186 views1 answer
Q operator in plsql
SQL
0 vote173 views2 answers
Get top 1 row of each group
SQL
0 vote191 views1 answer
Recover deleted data from mysql database
SQL
0 vote273 views1 answer
Trigger
SQL
2 votes186 views1 answer
Set column to not null mysql
SQL