Name |
Value |
Not For Replication |
|
SalesPersonQuotaHistory column |
SalesPerson column |
Type |
BusinessEntityID |
BusinessEntityID |
int |
Name |
Value |
MS_Description |
Foreign key constraint referencing SalesPerson.SalesPersonID. |
/ -->
ALTER TABLE [Sales].[SalesPersonQuotaHistory]
WITH CHECK
ADD CONSTRAINT [FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID]
FOREIGN KEY ([BusinessEntityID]) REFERENCES [Sales].[SalesPerson] ([BusinessEntityID])
ALTER TABLE [Sales].[SalesPersonQuotaHistory]
CHECK CONSTRAINT [FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing SalesPerson.SalesPersonID.', 'SCHEMA', N'Sales', 'TABLE', N'SalesPersonQuotaHistory', 'CONSTRAINT', N'FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID'
GO
|