Answers for "sql create table foreign key postgresql"

postgres add foreign key to existing table

ALTER TABLE tblA ADD COLUMN colA VARCHAR(10); /* 1st add column */
ALTER TABLE tblA ADD CONSTRAINT colA /* Make colA on tblA a foreign key */
FOREIGN KEY (colA) REFERENCES tblB (colB); /* colB must be a pk on tblB*/

Posted by: Guest on August-27-2021

Code answers related to "sql create table foreign key postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql create table foreign key postgresql"

Code answers related to "sql create table foreign key postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql create table foreign key postgresql"

Code answers related to "sql create table foreign key postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us