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 vote369 views1 answer
Reset postgres table index to next max value
SQL
0 vote371 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote366 views1 answer
Can you write relational algebra into sql queries
SQL
1 vote353 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote327 views1 answer
Dnsmasq.conf location macos
SQL
0 vote365 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote316 views1 answer
Show all mongodb
SQL
3 votes355 views1 answer
Oracle list dates without weekends
SQL
2 votes337 views1 answer
Oracle sql day of month from date
SQL
0 vote338 views1 answer
Mysql foreach insert
SQL