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

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

Revision as of 22:56, 28 December 2009

wikibot

type dbo.Name 
CREATE TYPE dbo.[Name] FROM nvarchar(100) 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


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