# Schema: Purchasing

## Properties

Name | Value
--- | ---
Name | Purchasing
ID | 8
Owner | dbo

## Extended Properties

Name | Value
--- | ---
MS_Description | Contains objects related to vendors and purchase orders.

## Permissions

No object level permissions defined.

## Objects

Name | Type
--- | ---
CK_ProductVendor_AverageLeadTime | CHECK constraint
CK_ProductVendor_LastReceiptCost | CHECK constraint
CK_ProductVendor_MaxOrderQty | CHECK constraint
CK_ProductVendor_MinOrderQty | CHECK constraint
CK_ProductVendor_OnOrderQty | CHECK constraint
CK_ProductVendor_StandardPrice | CHECK constraint
CK_PurchaseOrderDetail_OrderQty | CHECK constraint
CK_PurchaseOrderDetail_ReceivedQty | CHECK constraint
CK_PurchaseOrderDetail_RejectedQty | CHECK constraint
CK_PurchaseOrderDetail_UnitPrice | CHECK constraint
CK_PurchaseOrderHeader_Freight | CHECK constraint
CK_PurchaseOrderHeader_ShipDate | CHECK constraint
CK_PurchaseOrderHeader_Status | CHECK constraint
CK_PurchaseOrderHeader_SubTotal | CHECK constraint
CK_PurchaseOrderHeader_TaxAmt | CHECK constraint
CK_ShipMethod_ShipBase | CHECK constraint
CK_ShipMethod_ShipRate | CHECK constraint
CK_Vendor_CreditRating | CHECK constraint
FK_ProductVendor_Product_ProductID | FOREIGN KEY constraint
FK_ProductVendor_UnitMeasure_UnitMeasureCode | FOREIGN KEY constraint
FK_ProductVendor_Vendor_BusinessEntityID | FOREIGN KEY constraint
FK_PurchaseOrderDetail_Product_ProductID | FOREIGN KEY constraint
FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID | FOREIGN KEY constraint
FK_PurchaseOrderHeader_Employee_EmployeeID | FOREIGN KEY constraint
FK_PurchaseOrderHeader_ShipMethod_ShipMethodID | FOREIGN KEY constraint
FK_PurchaseOrderHeader_Vendor_VendorID | FOREIGN KEY constraint
FK_Vendor_BusinessEntity_BusinessEntityID | FOREIGN KEY constraint
PK_ProductVendor_ProductID_BusinessEntityID | PRIMARY KEY constraint
PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | PRIMARY KEY constraint
PK_PurchaseOrderHeader_PurchaseOrderID | PRIMARY KEY constraint
PK_ShipMethod_ShipMethodID | PRIMARY KEY constraint
PK_Vendor_BusinessEntityID | PRIMARY KEY constraint
dVendor | SQL DML trigger
iPurchaseOrderDetail | SQL DML trigger
uPurchaseOrderDetail | SQL DML trigger
uPurchaseOrderHeader | SQL DML trigger
ProductVendor | Table (user-defined)
PurchaseOrderDetail | Table (user-defined)
PurchaseOrderHeader | Table (user-defined)
ShipMethod | Table (user-defined)
Vendor | Table (user-defined)
vVendorWithAddresses | View
vVendorWithContacts | View

## SQL

Script
CREATE SCHEMA [Purchasing] AUTHORIZATION [dbo] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Contains objects related to vendors and purchase orders.' , @level0type=N'SCHEMA',@level0name=N'Purchasing'

#### See also

List of Schemas