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