Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
[...] Description Contains objects related to products, inventory, and manufacturing. Source
CREATE SCHEMA Production AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object Schema Table Production.BillOfMaterials Schema Table Production.Culture Schema Table Production.Document Schema Table Production.Illustration Schema Table Production.Location Schema [...]
wikibot
Schema Sales Description Contains objects related to customers, sales orders, and sales territories. Source
CREATE SCHEMA Sales AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object Schema Table Sales.ContactCreditCard Schema Table Sales.CountryRegionCurrency Schema Table Sales.CreditCard Schema [...]
wikibot
Schema [...]
wikibot
Schema HumanResources Description Contains objects related to employees and departments. Source
CREATE SCHEMA HumanResources AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object Schema Table HumanResources.Department Schema Table HumanResources.Employee Schema Table HumanResources.EmployeeAddress Schema Table HumanResources.EmployeeDepartmentHistory [...]
wikibot
Table Person.Contact Description Names of each employee, customer contact, and vendor contact. Columns Column Data Type Nullable Default Description ContactID int not null Primary key for Contact records. NameStyle dbo.NameStyle not null ((0)) 0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order. Title nvarchar(8) null A courtesy title. For example, Mr. or Ms. FirstName dbo.Name not null First name of the person. [...]
[...] [Sales].[Store] s
INNER JOIN [Sales].[StoreContact] sc
ON sc.[CustomerID] = s.[CustomerID]
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = sc.[ContactID]
INNER JOIN [Person].[ContactType] ct
ON sc.[ContactTypeID] = ct.[ContactTypeID]
INNER JOIN [Sales].[CustomerAddress] ca
ON ca.[CustomerID] = s.[CustomerID]
INNER JOIN [Person].[Address] a
ON a.[AddressID] = ca.[AddressID]
INNER JOIN [Person].[StateProvince] sp
ON sp.[StateProvinceID] = a.[StateProvinceID]
[...]
[...] ,[CountryRegionName] = cr.[Name]
,i.[Demographics]
FROM [Sales].[Individual] i
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = i.[ContactID]
INNER JOIN [Sales].[CustomerAddress] ca
ON ca.[CustomerID] = i.[CustomerID]
INNER JOIN [Person].[Address] a
ON a.[AddressID] = ca.[AddressID]
INNER JOIN [Person].[StateProvince] sp
ON sp.[StateProvinceID] = a.[StateProvinceID]
INNER JOIN [Person].[CountryRegion] cr
ON cr.[CountryRegionCode] = sp.[CountryRegionCode]
[...]
[...] v
INNER JOIN [Purchasing].[VendorContact] vc
ON vc.[VendorID] = v.[VendorID]
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = vc.[ContactID]
INNER JOIN [Person].[ContactType] ct
ON vc.[ContactTypeID] = ct.[ContactTypeID]
INNER JOIN [Purchasing].[VendorAddress] va
ON va.[VendorID] = v.[VendorID]
INNER JOIN [Person].[Address] a
ON a.[AddressID] = va.[AddressID]
INNER JOIN [Person].[StateProvince] sp
ON sp.[StateProvinceID] = a.[StateProvinceID]
[...]
[...] Purchasing Description Contains objects related to vendors and purchase orders. Source
CREATE SCHEMA Purchasing AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object Schema Table Purchasing.ProductVendor Schema [...]
wikibot
XML Schema Collection Person.AdditionalContactInfoSchemaCollection Description Collection of XML schemas for the AdditionalContactInfo column in the Person.Contact table. Source
[...]
wikibot adventureworks (mie60) Tables
Address (Person)
AddressType (Person)
AWBuildVersion (dbo)
BillOfMaterials (Production)
Contact (Person)
ContactCreditCard (Sales)
ContactType (Person)
CountryRegion (Person)
CountryRegionCurrency (Sales)
CreditCard (Sales)
Culture (Production)
Currency (Sales)
CurrencyRate (Sales)
Customer (Sales)
CustomerAddress (Sales)
DatabaseLog (dbo) [...]
wikibot
View Person.vStateProvinceCountryRegion Description Joins StateProvince table with CountryRegion table. Source
CREATE VIEW [Person].[vStateProvinceCountryRegion]
WITH SCHEMABINDING
AS
SELECT
sp.[StateProvinceID]
,sp.[StateProvinceCode]
,sp.[IsOnlyStateProvinceFlag]
,sp.[Name] AS [StateProvinceName]
,sp.[TerritoryID]
,cr.[CountryRegionCode]
,cr.[Name] AS [CountryRegionName]
FROM [Person].[StateProvince] sp
INNER JOIN [...]
wikibot
View Person.vAdditionalContactInfo Description Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person. Source
CREATE VIEW [Person].[vAdditionalContactInfo]
AS
SELECT
[ContactID]
,[FirstName]
,[MiddleName]
,[LastName]
,[ContactInfo].ref.value(N'declare namespace ci="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ContactInfo";
declare namespace act="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ContactTypes"; [...]
[...] LEFT OUTER JOIN [Sales].[SalesTerritory] st
ON st.[TerritoryID] = s.[TerritoryID]
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = e.[ContactID]
INNER JOIN [HumanResources].[EmployeeAddress] ea
ON e.[EmployeeID] = ea.[EmployeeID]
INNER JOIN [Person].[Address] a
ON ea.[AddressID] = a.[AddressID]
INNER JOIN [Person].[StateProvince] sp
ON sp.[StateProvinceID] = a.[StateProvinceID]
INNER JOIN [Person].[CountryRegion] cr
ON cr.[CountryRegionCode] [...]
[...] [CountryRegionName]
,c.[AdditionalContactInfo]
FROM [HumanResources].[Employee] e
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = e.[ContactID]
INNER JOIN [HumanResources].[EmployeeAddress] ea
ON e.[EmployeeID] = ea.[EmployeeID]
INNER JOIN [Person].[Address] a
ON ea.[AddressID] = a.[AddressID]
INNER JOIN [Person].[StateProvince] sp
ON sp.[StateProvinceID] = a.[StateProvinceID]
INNER JOIN [Person].[CountryRegion] cr
ON cr.[CountryRegionCode] [...]
wikibot
Table Person.StateProvince Description State and province lookup table. Columns Column Data Type Nullable Default Description StateProvinceID int not null Primary key for StateProvince records. StateProvinceCode nchar(3) not null ISO standard state or province code. CountryRegionCode nvarchar(3) not null ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. IsOnlyStateProvinceFlag dbo.Flag not null ((1)) 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode. Name dbo.Name [...]
[...] SELECT
@ContactID = ContactID,
@FirstName = FirstName,
@LastName = LastName
FROM [Person].[Contact]
WHERE [ContactID] = @ContactID;
SET @JobTitle =
CASE
-- Check for employee
WHEN EXISTS(SELECT * FROM [HumanResources].[Employee] e
WHERE e.[ContactID] = @ContactID)
THEN (SELECT [Title]
FROM [HumanResources].[Employee]
WHERE [ContactID] = @ContactID)
-- Check for vendor
WHEN EXISTS(SELECT * FROM [Purchasing].[VendorContact] vc
INNER JOIN [Person].[ContactType] [...]
wikibot
Table Person.CountryRegion Description Lookup table containing the ISO standard codes for countries and regions. Columns Column Data Type Nullable Default Description CountryRegionCode nvarchar(3) not null ISO standard code for countries and regions. Name dbo.Name not null Country or region name. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_CountryRegion_CountryRegionCode CountryRegionCode Indexes Index Type Columns AK_CountryRegion_Name Unique [...]
[...] Rejected; 5 = Shipped; 6 = Cancelled OnlineOrderFlag dbo.Flag not null ((1)) 0 = Order placed by sales person. 1 = Order placed online by customer. SalesOrderNumber Unique sales order identification number. PurchaseOrderNumber dbo.OrderNumber null Customer purchase order number reference. AccountNumber dbo.AccountNumber null Financial accounting number reference. CustomerID int not null Customer identification number. Foreign key to Customer.CustomerID. ContactID int not null Customer contact identification number. Foreign key to Contact.ContactID. [...]
wikibot
Table Person.Address Description Street address information for customers, employees, and vendors. Columns Column Data Type Nullable Default Description AddressID int not null Primary key for Address records. AddressLine1 nvarchar(60) not null First street address line. AddressLine2 nvarchar(60) null Second street address line. City nvarchar(30) not null Name of the city. StateProvinceID int not null Unique identification number for the state or province. Foreign key to StateProvince table. PostalCode nvarchar(15) not null [...]
wikibot
Table Person.AddressType Description Types of addresses stored in the Address table. Columns Column Data Type Nullable Default Description AddressTypeID int not null Primary key for AddressType records. Name dbo.Name not null Address type description. For example, Billing, Home, or Shipping. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary [...]
wikibot
Table Person.ContactType Description Lookup table containing the types of contacts stored in Contact. Columns Column Data Type Nullable Default Description ContactTypeID int not null Primary key for ContactType records. Name dbo.Name not null Contact type description. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_ContactType_ContactTypeID ContactTypeID Indexes Index Type Columns AK_ContactType_Name Unique Name Detail Tables Detail Table Column [...]
[...] DATABASE
FOR DDL_DATABASE_LEVEL_EVENTS AS
BEGIN
SET NOCOUNT ON;
DECLARE @data XML;
DECLARE @schema sysname;
DECLARE @object sysname;
DECLARE @eventType sysname;
SET @data = EVENTDATA();
SET @eventType = @data.value('(/EVENT_INSTANCE/EventType)[1]', 'sysname');
SET @schema = @data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'sysname');
SET @object = @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'sysname')
IF @object IS NOT NULL
PRINT ' ' + @eventType + ' - ' + @schema + '.' [...]
wikibot
XML Schema Collection Production.ManuInstructionsSchemaCollection Description Collection of XML schemas for the Instructions column in the Production.ProductModel table. Source
References Dependency Type [...]
[...] Data Type Table HumanResources.Department Data Type Table HumanResources.Shift Data Type Table Person.AddressType Data Type Table Person.Contact [...]
wikibot
XML Schema Collection Production.ProductDescriptionSchemaCollection Description Collection of XML schemas for the CatalogDescription column in the Production.ProductModel table. Source
References Dependency Type Object Type Referenced Object [...]
wikibot
XML Schema Collection HumanResources.HRResumeSchemaCollection Description Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table. Source
[...]
wikibot
XML Schema Collection Sales.StoreSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Store table. Source
References [...]
wikibot
XML Schema Collection Sales.IndividualSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Individual table. Source
References Dependency Type Object Type Referenced Object [...]
[...] IX_StoreContact_ContactTypeID ContactTypeID Foreign Keys Relation Column Referenced Column Person.Contact ContactID ContactID Person.ContactType ContactTypeID ContactTypeID Sales.Store CustomerID CustomerID References [...]