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

9 votes192 views6 answers
Replace sql
SQL
0 vote151 views3 answers
Sql parenthetical expression examples
SQL
0 vote210 views1 answer
Mariadb date equals to current_date plus days
SQL
1 vote214 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote183 views1 answer
How to check rollback status in oracle
SQL
0 vote198 views1 answer
Insert query return id mysql
SQL
0 vote152 views1 answer
How to inner join 4 tables in sql
SQL
2 votes145 views1 answer
Where clause for child record apex
SQL
2 votes149 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
0 vote150 views1 answer
What is mysql_pconnect
SQL