/SQL/Postgres remove foreign key constraint

Postgres remove foreign key constraint

Postgres remove foreign key constraint

ALTER TABLE your_tbl DROP constraint your_cnstrnt;

1

How to disable foreign key constraint in postgresql

ALTER TABLE tbl_StudentMarks DISABLE TRIGGER ALL;

1

Source: dbrnd.com

Postgres disable foreign keys

SET session_replication_role = replica;

0

Source: stackoverflow.com

Similar codes

0 vote279 views2 answers
How to see table associated with a schema in sql
SQL
15 votes311 views3 answers
Postgresql change column type
SQL
0 vote291 views1 answer
Sql change date format
SQL
1 vote246 views1 answer
Oracle boolean to varchar
SQL
0 vote241 views2 answers
Denormalization in sql
SQL
0 vote277 views2 answers
Mysql get routine parameter list
SQL
0 vote290 views1 answer
What is default mysql database password in linux
SQL
0 vote289 views1 answer
Sqlite update only if greater
SQL
0 vote234 views1 answer
Oracle sql replace string in clob
SQL
0 vote314 views1 answer
One table with another
SQL

Share