Relationship:
FK_Customer_Person_PersonID
on
Customer
Name | Value |
Not For Replication |
Customer column | Person column | Type |
PersonID | BusinessEntityID | int |
Name | Value |
MS_Description | Foreign key constraint referencing Person.BusinessEntityID. |
ALTER TABLE [Sales].[Customer] WITH CHECK ADD CONSTRAINT [FK_Customer_Person_PersonID] FOREIGN KEY ([PersonID]) REFERENCES [Person].[Person] ([BusinessEntityID]) ALTER TABLE [Sales].[Customer] CHECK CONSTRAINT [FK_Customer_Person_PersonID] GO EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Person.BusinessEntityID.', 'SCHEMA', N'Sales', 'TABLE', N'Customer', 'CONSTRAINT', N'FK_Customer_Person_PersonID' GO |