Difference between revisions of "Dbo.Name (type)"
| 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 === | === Source === | ||
| Line 21: | 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 | ||
| − | | [[Sales.Store_(table)|Sales.Store]] | + | | [[Sales.Store_(_(table))|Sales.Store]] |
|} | |} | ||
Revision as of 22:59, 23 June 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 |
