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

2 votes172 views1 answer
Revokeprivileges mysql
SQL
0 vote178 views1 answer
When mysql server would not work in xampp
SQL
0 vote154 views1 answer
Declare or use variable in snowflake
SQL
13 votes304 views4 answers
Sql joining 3 tables
SQL
1 vote165 views2 answers
Mysql limit offset
SQL
0 vote155 views1 answer
Mysql update even / odd rows
SQL
8 votes148 views1 answer
Oracle add months to sysdate
SQL
3 votes186 views1 answer
Oracle detect invalid password
SQL
0 vote155 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
1 vote149 views1 answer
Mysql get latest duplicate rows
SQL