Relationship:
FK_PersonPhone_Person_BusinessEntityID
on
PersonPhone
Relationship properties
| Name | Value |
| Not For Replication |
FK columns
| PersonPhone column | Person column | Type |
| BusinessEntityID | BusinessEntityID | int |
SQL
ALTER TABLE [Person].[PersonPhone] WITH CHECK ADD CONSTRAINT [FK_PersonPhone_Person_BusinessEntityID] FOREIGN KEY ([BusinessEntityID]) REFERENCES [Person].[Person] ([BusinessEntityID]) ALTER TABLE [Person].[PersonPhone] CHECK CONSTRAINT [FK_PersonPhone_Person_BusinessEntityID] GO |
See also