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

From dbscript Online Help
Jump to: navigation, search
 
(6 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.Name
 
| dbo.Name
−
|-
 
 
|}
 
|}
  
 +
=== Source ===
 
<pre>
 
<pre>
 
CREATE TYPE dbo.[Name] FROM nvarchar(100) NULL
 
CREATE TYPE dbo.[Name] FROM nvarchar(100) NULL
 
</pre>
 
</pre>
−
== automatically generated ==
 
  
 +
=== Dependencies ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- style="background:silver"
−
| '''type
+
| '''Reference Type
−
| dbo.Name
+
| '''Object Type
 +
| '''Referencing Object
 +
 
 +
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[HumanResources.Department_(table)|HumanResources.Department]]
 +
 
 +
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[HumanResources.Shift_(table)|HumanResources.Shift]]
 +
 
 +
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[Person.AddressType_(table)|Person.AddressType]]
 +
 
 +
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[Person.Contact_(table)|Person.Contact]]
 +
 
 +
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[Person.ContactType_(table)|Person.ContactType]]
 +
 
 +
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[Person.CountryRegion_(table)|Person.CountryRegion]]
 +
 
 
|- valign="top"
 
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[Person.StateProvince_(table)|Person.StateProvince]]
  
−
|}
+
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[Production.Culture_(table)|Production.Culture]]
  
−
<pre>
+
|- valign="top"
−
CREATE TYPE dbo.[Name] FROM nvarchar(50) NULL
+
| Data Type
−
</pre>
+
| Table
 +
| [[Production.Location_(table)|Production.Location]]
  
 +
|- valign="top"
 +
| Data Type
 +
| Table
 +
| [[Production.Product_(table)|Production.Product]]
  
−
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
+
|- valign="top"
−
|- style="background:silver"
+
| Data Type
−
| '''Referencing Object
+
| Table
−
| '''Object Type
+
| [[Production.ProductCategory_(table)|Production.ProductCategory]]
−
| '''Reference Type
 
  
−
|-
+
|- valign="top"
−
| [[HumanResources.Department_(table)|HumanResources.Department]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Production.ProductModel_(table)|Production.ProductModel]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
−
|-
 
−
| [[HumanResources.Shift_(table)|HumanResources.Shift]]
 
 
| Table
 
| Table
 +
| [[Production.ProductReview_(table)|Production.ProductReview]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Person.AddressType_(table)|Person.AddressType]]
 
 
| Table
 
| Table
 +
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Person.Contact_(table)|Person.Contact]]
 
 
| Table
 
| Table
 +
| [[Production.ScrapReason_(table)|Production.ScrapReason]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Person.ContactType_(table)|Person.ContactType]]
 
 
| Table
 
| Table
 +
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Person.CountryRegion_(table)|Person.CountryRegion]]
 
 
| Table
 
| Table
 +
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Person.StateProvince_(table)|Person.StateProvince]]
 
 
| Table
 
| Table
 +
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Production.Culture_(table)|Production.Culture]]
 
 
| Table
 
| Table
 +
| [[Sales.Currency_(table)|Sales.Currency]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Production.Location_(table)|Production.Location]]
 
 
| Table
 
| Table
 +
| [[Sales.SalesReason_(table)|Sales.SalesReason]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Production.Product_(table)|Production.Product]]
 
 
| Table
 
| Table
 +
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Production.ProductCategory_(table)|Production.ProductCategory]]
 
 
| Table
 
| Table
 +
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 +
 +
|- valign="top"
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Sales.Store_(table)|Sales.Store]]
 +
 +
|}
 +
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''type
 +
| dbo.Name
 
|-
 
|-
−
| [[Production.ProductModel_(table)|Production.ProductModel]]
+
|}
 +
 
 +
<pre>
 +
CREATE TYPE dbo.[Name] FROM nvarchar(50) NULL
 +
</pre>
 +
 
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 
 +
|-
 +
| Data Type
 
| Table
 
| Table
 +
| [[HumanResources.Department_(table)|HumanResources.Department]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[HumanResources.Shift_(table)|HumanResources.Shift]]
 +
 
|-
 
|-
−
| [[Production.ProductReview_(table)|Production.ProductReview]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Person.AddressType_(table)|Person.AddressType]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Person.Contact_(table)|Person.Contact]]
 +
 
|-
 
|-
−
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Person.ContactType_(table)|Person.ContactType]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Person.CountryRegion_(table)|Person.CountryRegion]]
 +
 
|-
 
|-
−
| [[Production.ScrapReason_(table)|Production.ScrapReason]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Person.StateProvince_(table)|Person.StateProvince]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Production.Culture_(table)|Production.Culture]]
 +
 
|-
 
|-
−
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Production.Location_(table)|Production.Location]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Production.Product_(table)|Production.Product]]
 +
 
|-
 
|-
−
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Production.ProductCategory_(table)|Production.ProductCategory]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Production.ProductModel_(table)|Production.ProductModel]]
 +
 
|-
 
|-
−
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Production.ProductReview_(table)|Production.ProductReview]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
 +
 
|-
 
|-
−
| [[Sales.Currency_(table)|Sales.Currency]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Production.ScrapReason_(table)|Production.ScrapReason]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
 +
 
|-
 
|-
−
| [[Sales.SalesReason_(table)|Sales.SalesReason]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 +
 
|-
 
|-
−
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Sales.Currency_(table)|Sales.Currency]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Sales.SalesReason_(table)|Sales.SalesReason]]
 +
 
|-
 
|-
−
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 +
 
|-
 
|-
 +
| Data Type
 +
| Table
 
| [[Sales.Store_(table)|Sales.Store]]
 
| [[Sales.Store_(table)|Sales.Store]]
−
| Table
+
 
−
| Data Type
 
 
|}
 
|}

Latest revision as of 09:54, 27 August 2011

wikibot[edit]

type dbo.Name

Source[edit]

CREATE TYPE dbo.[Name] FROM nvarchar(100) NULL

Dependencies[edit]

Reference Type Object Type Referencing Object
Data Type Table HumanResources.Department
Data Type Table HumanResources.Shift
Data Type Table Person.AddressType
Data Type Table Person.Contact
Data Type Table Person.ContactType
Data Type Table Person.CountryRegion
Data Type Table Person.StateProvince
Data Type Table Production.Culture
Data Type Table Production.Location
Data Type Table Production.Product
Data Type Table Production.ProductCategory
Data Type Table Production.ProductModel
Data Type Table Production.ProductReview
Data Type Table Production.ProductSubcategory
Data Type Table Production.ScrapReason
Data Type Table Production.UnitMeasure
Data Type Table Purchasing.ShipMethod
Data Type Table Purchasing.Vendor
Data Type Table Sales.Currency
Data Type Table Sales.SalesReason
Data Type Table Sales.SalesTaxRate
Data Type Table Sales.SalesTerritory
Data Type Table Sales.Store


automatically generated[edit]

type dbo.Name 
CREATE TYPE dbo.[Name] FROM nvarchar(50) NULL


Reference Type Object Type Referencing Object
Data Type Table HumanResources.Department
Data Type Table HumanResources.Shift
Data Type Table Person.AddressType
Data Type Table Person.Contact
Data Type Table Person.ContactType
Data Type Table Person.CountryRegion
Data Type Table Person.StateProvince
Data Type Table Production.Culture
Data Type Table Production.Location
Data Type Table Production.Product
Data Type Table Production.ProductCategory
Data Type Table Production.ProductModel
Data Type Table Production.ProductReview
Data Type Table Production.ProductSubcategory
Data Type Table Production.ScrapReason
Data Type Table Production.UnitMeasure
Data Type Table Purchasing.ShipMethod
Data Type Table Purchasing.Vendor
Data Type Table Sales.Currency
Data Type Table Sales.SalesReason
Data Type Table Sales.SalesTaxRate
Data Type Table Sales.SalesTerritory
Data Type Table Sales.Store
Retrieved from "http://dbshelp.devio.at/index.php?title=Dbo.Name_(type)&oldid=2923"