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

From dbscript Online Help
Jump to: navigation, search
Line 28: Line 28:
 
{| 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
 
| [[HumanResources.Department_(table)|HumanResources.Department]]
 
| [[HumanResources.Department_(table)|HumanResources.Department]]
 +
 +
|-
 +
| Data Type
 
| Table
 
| Table
 +
| [[HumanResources.Shift_(table)|HumanResources.Shift]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Person.AddressType_(table)|Person.AddressType]]
 +
 
|-
 
|-
−
| [[HumanResources.Shift_(table)|HumanResources.Shift]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Person.Contact_(table)|Person.Contact]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Person.ContactType_(table)|Person.ContactType]]
 +
 
|-
 
|-
−
| [[Person.AddressType_(table)|Person.AddressType]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Person.CountryRegion_(table)|Person.CountryRegion]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Person.StateProvince_(table)|Person.StateProvince]]
 +
 
|-
 
|-
−
| [[Person.Contact_(table)|Person.Contact]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Production.Culture_(table)|Production.Culture]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Production.Location_(table)|Production.Location]]
 +
 
|-
 
|-
−
| [[Person.ContactType_(table)|Person.ContactType]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Production.Product_(table)|Production.Product]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Production.ProductCategory_(table)|Production.ProductCategory]]
 +
 
|-
 
|-
−
| [[Person.CountryRegion_(table)|Person.CountryRegion]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Production.ProductModel_(table)|Production.ProductModel]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Production.ProductReview_(table)|Production.ProductReview]]
 +
 
|-
 
|-
−
| [[Person.StateProvince_(table)|Person.StateProvince]]
+
| Data Type
 
| Table
 
| Table
 +
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
 +
 +
|-
 
| Data Type
 
| Data Type
 +
| Table
 +
| [[Production.ScrapReason_(table)|Production.ScrapReason]]
 +
 
|-
 
|-
−
| [[Production.Culture_(table)|Production.Culture]]
+
| Data Type
 
| Table
 
| Table
−
| Data Type
+
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
 +
 
 
|-
 
|-
−
| [[Production.Location_(table)|Production.Location]]
 
−
| Table
 
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Production.Product_(table)|Production.Product]]
 
 
| Table
 
| Table
−
| Data Type
+
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
 +
 
 
|-
 
|-
−
| [[Production.ProductCategory_(table)|Production.ProductCategory]]
 
−
| Table
 
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Production.ProductModel_(table)|Production.ProductModel]]
 
 
| Table
 
| Table
−
| Data Type
+
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 +
 
 
|-
 
|-
−
| [[Production.ProductReview_(table)|Production.ProductReview]]
 
−
| Table
 
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]]
 
 
| Table
 
| Table
−
| Data Type
+
| [[Sales.Currency_(table)|Sales.Currency]]
 +
 
 
|-
 
|-
−
| [[Production.ScrapReason_(table)|Production.ScrapReason]]
 
−
| Table
 
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]]
 
 
| Table
 
| Table
−
| Data Type
+
| [[Sales.SalesReason_(table)|Sales.SalesReason]]
 +
 
 
|-
 
|-
−
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]]
 
−
| Table
 
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 
 
| Table
 
| Table
−
| Data Type
+
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]]
 +
 
 
|-
 
|-
−
| [[Sales.Currency_(table)|Sales.Currency]]
 
−
| Table
 
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Sales.SalesReason_(table)|Sales.SalesReason]]
 
 
| Table
 
| Table
−
| Data Type
+
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 +
 
 
|-
 
|-
−
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]]
 
−
| Table
 
 
| Data Type
 
| Data Type
−
|-
 
−
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 
 
| Table
 
| Table
−
| Data Type
 
−
|-
 
 
| [[Sales.Store_(table)|Sales.Store]]
 
| [[Sales.Store_(table)|Sales.Store]]
−
| Table
+
 
−
| Data Type
 
 
|}
 
|}

Revision as of 07:39, 30 November 2009

wikibot

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

automatically generated

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=1708"