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

1 vote124 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote114 views1 answer
Primary key reset in SQL database
SQL
15 votes116 views2 answers
How to know the username of postgresql
SQL
25 votes119 views3 answers
Mysql command show tables
SQL
0 vote128 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
3 votes111 views3 answers
Into in sql
SQL
0 vote115 views1 answer
Pgadmin save data greyed out
SQL
2 votes123 views1 answer
Sql server case sensitive search
SQL
0 vote114 views1 answer
Oracle running queries sql
SQL
15 votes116 views4 answers
Pl sql
SQL