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