Answers for "how to add foreign key with another table in postgresql"

SQL
3

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 "how to add foreign key with another table in postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language