Relationship: FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID on PersonPhone

CollapseAll image

Collapse image Relationship properties


 Name   Value 
 Not For Replication   

Collapse image FK columns


PersonPhone column PhoneNumberType column Type
PhoneNumberTypeID PhoneNumberTypeID int

Collapse image 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

Collapse image See also


[Person].[PersonPhone]

[Person].[PhoneNumberType]