| Name |
Value |
| Not For Replication |
|
| PurchaseOrderHeader column |
Employee column |
Type |
| EmployeeID |
BusinessEntityID |
int |
| Name |
Value |
| MS_Description |
Foreign key constraint referencing Employee.EmployeeID. |
/ -->
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
WITH CHECK
ADD CONSTRAINT [FK_PurchaseOrderHeader_Employee_EmployeeID]
FOREIGN KEY ([EmployeeID]) REFERENCES [HumanResources].[Employee] ([BusinessEntityID])
ALTER TABLE [Purchasing].[PurchaseOrderHeader]
CHECK CONSTRAINT [FK_PurchaseOrderHeader_Employee_EmployeeID]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Employee.EmployeeID.', 'SCHEMA', N'Purchasing', 'TABLE', N'PurchaseOrderHeader', 'CONSTRAINT', N'FK_PurchaseOrderHeader_Employee_EmployeeID'
GO
|