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'

Schema: Purchasing

Properties

Extended Properties

Permissions

Objects

SQL

See also