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