Difference between revisions of "Purchasing (schema)"

From dbscript Online Help
Jump to: navigation, search
Line 17: Line 17:
 
| '''schema
 
| '''schema
 
| .Purchasing
 
| .Purchasing
|-
+
|- valign="top"
  
 
| '''Description
 
| '''Description
Line 28: Line 28:
 
CREATE SCHEMA Purchasing AUTHORIZATION dbo
 
CREATE SCHEMA Purchasing AUTHORIZATION dbo
 
</pre>
 
</pre>
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Referencing Object
 +
| '''Object Type
 +
| '''Reference Type
 +
 +
|-
 +
| [[Purchasing.ProductVendor_(table)|Purchasing.ProductVendor]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Purchasing.VendorAddress_(table)|Purchasing.VendorAddress]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]]
 +
| Table
 +
| Schema
 +
|-
 +
| [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
 +
| View
 +
| Schema
 +
|}

Revision as of 07:25, 30 November 2009

wikibot

schema .Purchasing
CREATE SCHEMA Purchasing AUTHORIZATION dbo

automatically generated

schema .Purchasing
Description Contains objects related to vendors and purchase orders.
CREATE SCHEMA Purchasing AUTHORIZATION dbo


Referencing Object Object Type Reference Type
Purchasing.ProductVendor Table Schema
Purchasing.PurchaseOrderDetail Table Schema
Purchasing.PurchaseOrderHeader Table Schema
Purchasing.ShipMethod Table Schema
Purchasing.Vendor Table Schema
Purchasing.VendorAddress Table Schema
Purchasing.VendorContact Table Schema
Purchasing.vVendor View Schema