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

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"
 
|-
 
|-
| '''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>
  
 
+
=== Dependencies ===
 
{| 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"
Line 135: Line 137:
  
 
|}
 
|}
 
  
  

Revision as of 23:08, 2 February 2010

wikibot

Type dbo.Name


Source

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

Dependencies

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