AdventureWorks

Description

none

name	base type	length	nulls	default	rule
Name	nvarchar	100	True

name	object type	level
Department	table	1
vEmployeeDepartmentHistory	view	2
vEmployeeDepartment	view	2
Shift	table	1
AddressType	table	1
vStoreWithDemographics	view	2
vIndividualCustomer	view	2
Contact	table	1
vSalesPersonSalesByFiscalYears	view	2
vSalesPerson	view	2
vVendor	view	2
vAdditionalContactInfo	view	2
vEmployee	view	2
uspGetManagerEmployees	stored procedure	2
uspGetEmployeeManagers	stored procedure	2
ufnGetContactInformation	multi-statement table valued function	2
ContactType	table	1
CountryRegion	table	1
vStateProvinceCountryRegion	view	2
StateProvince	table	1
Culture	table	1
Location	table	1
Product	table	1
vProductAndDescription	view	2
uspGetWhereUsedProductID	stored procedure	2
uspGetBillOfMaterials	stored procedure	2
ufnGetProductStandardCost	function	2
ufnGetProductListPrice	function	2
ufnGetProductDealerPrice	function	2
ProductCategory	table	1
ProductModel	table	1
vProductModelInstructions	view	2
vProductModelCatalogDescription	view	2
ProductReview	table	1
ProductSubcategory	table	1
ScrapReason	table	1
UnitMeasure	table	1
ShipMethod	table	1
Vendor	table	1
dVendor	trigger	2
Currency	table	1
SalesReason	table	1
SalesTaxRate	table	1
SalesTerritory	table	1
uSalesOrderHeader	trigger	2
Store	table	1
iStore	trigger	2
iuIndividual	trigger	2

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