Difference between revisions of "Purchasing (schema)"

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

Revision as of 23:08, 2 February 2010

wikibot

Schema Purchasing
Description Contains objects related to vendors and purchase orders.


Source

CREATE SCHEMA Purchasing AUTHORIZATION dbo

Dependencies

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


automatically generated

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


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