Difference between revisions of "Dbo.Name (type)"
| (3 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> | ||
| − | + | === 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 19: | Line 19: | ||
| '''Referencing Object | | '''Referencing Object | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[HumanResources.Department_(table)|HumanResources.Department]] | | [[HumanResources.Department_(table)|HumanResources.Department]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[HumanResources.Shift_(table)|HumanResources.Shift]] | | [[HumanResources.Shift_(table)|HumanResources.Shift]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Person.AddressType_(table)|Person.AddressType]] | | [[Person.AddressType_(table)|Person.AddressType]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Person.Contact_(table)|Person.Contact]] | | [[Person.Contact_(table)|Person.Contact]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Person.ContactType_(table)|Person.ContactType]] | | [[Person.ContactType_(table)|Person.ContactType]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Person.CountryRegion_(table)|Person.CountryRegion]] | | [[Person.CountryRegion_(table)|Person.CountryRegion]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Person.StateProvince_(table)|Person.StateProvince]] | | [[Person.StateProvince_(table)|Person.StateProvince]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Production.Culture_(table)|Production.Culture]] | | [[Production.Culture_(table)|Production.Culture]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Production.Location_(table)|Production.Location]] | | [[Production.Location_(table)|Production.Location]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Production.Product_(table)|Production.Product]] | | [[Production.Product_(table)|Production.Product]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Production.ProductCategory_(table)|Production.ProductCategory]] | | [[Production.ProductCategory_(table)|Production.ProductCategory]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Production.ProductModel_(table)|Production.ProductModel]] | | [[Production.ProductModel_(table)|Production.ProductModel]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Production.ProductReview_(table)|Production.ProductReview]] | | [[Production.ProductReview_(table)|Production.ProductReview]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]] | | [[Production.ProductSubcategory_(table)|Production.ProductSubcategory]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Production.ScrapReason_(table)|Production.ScrapReason]] | | [[Production.ScrapReason_(table)|Production.ScrapReason]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | | [[Production.UnitMeasure_(table)|Production.UnitMeasure]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]] | | [[Purchasing.ShipMethod_(table)|Purchasing.ShipMethod]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]] | | [[Purchasing.Vendor_(table)|Purchasing.Vendor]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Sales.Currency_(table)|Sales.Currency]] | | [[Sales.Currency_(table)|Sales.Currency]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Sales.SalesReason_(table)|Sales.SalesReason]] | | [[Sales.SalesReason_(table)|Sales.SalesReason]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]] | | [[Sales.SalesTaxRate_(table)|Sales.SalesTaxRate]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] | | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Table | | Table | ||
| Line 135: | Line 135: | ||
|} | |} | ||
| − | |||
Latest revision as of 10: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 |
