Relationship:
FK_Store_SalesPerson_SalesPersonID
on
Store
Relationship properties
| Name | Value |
| Not For Replication |
FK columns
| Store column | SalesPerson column | Type |
| SalesPersonID | BusinessEntityID | int |
Extended properties
| Name | Value |
| MS_Description | Foreign key constraint referencing SalesPerson.SalesPersonID |
SQL
ALTER TABLE [Sales].[Store] WITH CHECK ADD CONSTRAINT [FK_Store_SalesPerson_SalesPersonID] FOREIGN KEY ([SalesPersonID]) REFERENCES [Sales].[SalesPerson] ([BusinessEntityID]) ALTER TABLE [Sales].[Store] CHECK CONSTRAINT [FK_Store_SalesPerson_SalesPersonID] GO EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing SalesPerson.SalesPersonID', 'SCHEMA', N'Sales', 'TABLE', N'Store', 'CONSTRAINT', N'FK_Store_SalesPerson_SalesPersonID' GO |
See also