Mega Code Archive

 

Categories / MSSQL Tutorial / Constraints

 

A statement that adds a foreign key constraint

ALTER TABLE YourTableName WITH CHECK ADD FOREIGN KEY (AccountNo) REFERENCES AnotherTableName(AccountNo)