Difference between revisions of "Dbo.AccountNumber (type)"

From dbscript Online Help
Jump to: navigation, search
 
(7 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''type
 
| '''type
 
| dbo.AccountNumber
 
| dbo.AccountNumber
|-
 
 
|}
 
|}
  
 +
=== Source ===
 
<pre>
 
<pre>
 
CREATE TYPE dbo.AccountNumber FROM nvarchar(30) NULL
 
CREATE TYPE dbo.AccountNumber FROM nvarchar(30) NULL
 
</pre>
 
</pre>
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 +
 +
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 +
 +
|}
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  
Line 18: Line 39:
 
| dbo.AccountNumber
 
| dbo.AccountNumber
 
|-
 
|-
 
 
|}
 
|}
  
Line 28: Line 48:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 
| '''Referencing Object
 
| '''Referencing Object
| '''Object Type
+
 
| '''Reference Type
 
 
 
|-
 
|-
 +
| Data Type
 +
| Table
 
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 +
 +
|-
 +
| Data Type
 
| Table
 
| Table
| Data Type
 
|-
 
 
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
| Table
+
 
| Data Type
 
 
|}
 
|}

Latest revision as of 09:54, 27 August 2011

wikibot[edit]

type dbo.AccountNumber

Source[edit]

CREATE TYPE dbo.AccountNumber FROM nvarchar(30) NULL

Dependencies[edit]

Reference Type Object Type Referencing Object
Data Type Table Purchasing.Vendor
Data Type Table Sales.SalesOrderHeader


automatically generated[edit]

type dbo.AccountNumber
CREATE TYPE dbo.AccountNumber FROM nvarchar(15) NULL


Reference Type Object Type Referencing Object
Data Type Table Purchasing.Vendor
Data Type Table Sales.SalesOrderHeader