SQL Server 2012 Visualization Settings foreign key

1: Graphical interface setting foreign key

Resolve:table-> Selected Table->design-> Select the field that you want to set the foreign key to, choose Relationships, select Add, select the right ellipsis (see figure I), and then select the relationship in the table and column specifications.

Figure One:

2: Common Commands

Primary key, foreign key, and referenced table for SQL Server query table: exec sp_helpconstraint ' table name '

SQL Server 2012 Visualization Settings foreign key