Name |
Value |
Not For Replication |
|
BusinessEntityContact column |
ContactType column |
Type |
ContactTypeID |
ContactTypeID |
int |
Name |
Value |
MS_Description |
Foreign key constraint referencing ContactType.ContactTypeID. |
/ -->
ALTER TABLE [Person].[BusinessEntityContact]
WITH CHECK
ADD CONSTRAINT [FK_BusinessEntityContact_ContactType_ContactTypeID]
FOREIGN KEY ([ContactTypeID]) REFERENCES [Person].[ContactType] ([ContactTypeID])
ALTER TABLE [Person].[BusinessEntityContact]
CHECK CONSTRAINT [FK_BusinessEntityContact_ContactType_ContactTypeID]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing ContactType.ContactTypeID.', 'SCHEMA', N'Person', 'TABLE', N'BusinessEntityContact', 'CONSTRAINT', N'FK_BusinessEntityContact_ContactType_ContactTypeID'
GO
|