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 vote164 views1 answer
Media sql
SQL
0 vote176 views1 answer
Mssql disable foreign key constraint
SQL
0 vote238 views1 answer
How to find sql server name
SQL
3 votes198 views1 answer
Define REGEXP?
SQL
0 vote173 views1 answer
Pl/sql loop example
SQL
16 votes176 views3 answers
Tsql rename column name
SQL
2 votes185 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
10 votes163 views4 answers
Join with multiple conditions sql
SQL
0 vote207 views1 answer
Psql create usr
SQL
0 vote170 views1 answer
Postgres enumerated type
SQL