SQL Server Transact Basic to Expert - Add Foreign Key to existing Column

Karthikeyan Anbarasan
13y
2.7k
0
0

Blog

This blog shows on adding a foreign key to an existing column table

Syntax:

ALTER TABLE tablename
ADD CONSTRAINT constraintname
FOREIGN KEY (columnname)
REFERENCES [ schemaname.] referencedtablename [ ( refcolumn ) ]

SQL Server Transact Basic to Expert - Add Foreign Key to existing Column

Up Next

SQL Server Transact Basic to Expert - Add Unique Constraints to Existing Table

Ebook Download

View all

Functions in SQL Server: Practical Guide

Read by 9k people

Download Now!

Learn

View all