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 [...]
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 [...]
wikibot
Schema Person Description Contains objects related to names and addresses of customers, vendors, and employees Source
CREATE SCHEMA Person AUTHORIZATION dbo
Dependencies Reference Type [...]
wikibot
XML Schema Collection Person.AdditionalContactInfoSchemaCollection Description Collection [...]
wikibot
XML Schema Collection Sales.IndividualSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Individual table. Source
[...]
wikibot
XML Schema Collection Sales.StoreSurveySchemaCollection Description Collection of XML schemas for the Demographics column in the Sales.Store table. Source
[...]
wikibot
XML Schema Collection Production.ProductDescriptionSchemaCollection Description Collection of XML [...]
wikibot
XML Schema Collection Production.ManuInstructionsSchemaCollection Description Collection of XML schemas for the Instructions column in the Production.ProductModel table. Source
[...]
wikibot
XML Schema Collection HumanResources.HRResumeSchemaCollection Description Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table. Source
[...]
[...] for ProductModel records. Name dbo.Name not null Product model description. CatalogDescription xml null Detailed product catalog information in xml format. Instructions xml null Manufacturing instructions in xml format. 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 Key [...]
[...] 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 [...]
[...] [ddlDatabaseTriggerLog] ON 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 + ' - [...]
[...] Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID. Resume xml null Résumé in XML format. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_JobCandidate_JobCandidateID JobCandidateID Indexes Index Type Columns IX_JobCandidate_EmployeeID EmployeeID Foreign Keys Relation Column Referenced Column HumanResources.Employee [...]
[...] Random value concatenated with the password string before the password is hashed. AdditionalContactInfo xml null Additional contact information about the person stored in xml format. 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 Key Columns PK_Contact_ContactID ContactID Indexes Index Type Columns AK_Contact_rowguid Unique rowguid [...]
[...] null Identifies the customer in the Contact table. Foreign key to Contact.ContactID. Demographics xml null Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Individual_CustomerID CustomerID Indexes Index Type Columns PXML_Individual_Demographics Demographics XMLPATH_Individual_Demographics Demographics XMLPROPERTY_Individual_Demographics Demographics XMLVALUE_Individual_Demographics [...]
[...] the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID. Demographics xml null Demographic informationg about the store such as the number of employees, annual sales and store type. 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 Key Columns PK_Store_CustomerID CustomerID Indexes Index Type Columns AK_Store_rowguid Unique rowguid [...]
wikibot Oracle Demo Schema (test 104 17.02.2011 23:58:21) Tables
AQ$_ORDERS_QUEUETABLE_G (IX)
AQ$_ORDERS_QUEUETABLE_H (IX)
AQ$_ORDERS_QUEUETABLE_I (IX)
AQ$_ORDERS_QUEUETABLE_S (IX)
AQ$_ORDERS_QUEUETABLE_T (IX)
AQ$_STREAMS_QUEUE_TABLE_G (IX)
AQ$_STREAMS_QUEUE_TABLE_H (IX)
AQ$_STREAMS_QUEUE_TABLE_I (IX)
AQ$_STREAMS_QUEUE_TABLE_S (IX)
AQ$_STREAMS_QUEUE_TABLE_T (IX)
CAL_MONTH_SALES_MV (SH)
CATEGORIES_TAB (OE)
CHANNELS (SH)
COSTS (SH)
COUNTRIES (HR)
COUNTRIES (SH)
CUSTOMERS (OE)
CUSTOMERS [...]
wikibot
Type OE.XDBPO_LINEITEM_COLLECTION Source
CREATE OR REPLACE TYPE "XDBPO_LINEITEM_COLLECTION" [...]
wikibot
Type OE.XDBPO_ACTION_COLLECTION Source
CREATE OR REPLACE TYPE "XDBPO_ACTION_COLLECTION" [...]
[...] Default Description IllustrationID int not null Primary key for Illustration records. Diagram xml null Illustrations used in manufacturing instructions. Stored as XML. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Illustration_IllustrationID IllustrationID Detail Tables Detail Table Column Referencing Column Production.ProductModelIllustration IllustrationID IllustrationID References [...]
[...] implemented the DDL change. Event sysname not null The type of DDL statement that was executed. Schema sysname null The schema to which the changed object belongs. Object sysname null The object that was changed by the DDL statment. TSQL nvarchar(max) not null The exact Transact-SQL [...]
[...] HumanResources.vJobCandidateEmployment Description Displays the content from each employement history related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed. Source
CREATE VIEW [HumanResources].[vJobCandidateEmployment]
AS
SELECT
jc.[JobCandidateID]
,CONVERT(datetime, REPLACE([Employment].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume"; [...]
[...] HumanResources.vJobCandidateEducation Description Displays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed. Source
CREATE VIEW [HumanResources].[vJobCandidateEducation]
AS
SELECT
jc.[JobCandidateID]
,[Education].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(Edu.Level)[1]', [...]
[...] Production.vProductModelInstructions Description Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions. Source
CREATE VIEW [Production].[vProductModelInstructions]
AS
SELECT
[ProductModelID]
,[Name]
,[Instructions].value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions";
(/root/text())[1]', 'nvarchar(max)') AS [Instructions]
,[MfgInstructions].ref.value('@LocationID[1]', [...]
[...] Production.vProductModelCatalogDescription Description Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data. Source
CREATE VIEW [Production].[vProductModelCatalogDescription]
AS
SELECT
[ProductModelID]
,[Name]
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";
declare namespace html="http://www.w3.org/1999/xhtml";
(/p1:ProductDescription/p1:Summary/html:p)[1]', [...]
[...] 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";
(act:telephoneNumber)[1]/act:number', 'nvarchar(50)') [...]
[...]
View Sales.vIndividualDemographics Description Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table. Source
CREATE VIEW [Sales].[vIndividualDemographics]
AS
SELECT
i.[CustomerID]
,[IndividualSurvey].[ref].[value](N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey";
TotalPurchaseYTD[1]', 'money') AS [TotalPurchaseYTD]
,CONVERT(datetime, REPLACE([IndividualSurvey].[ref].[value](N'declare default element namespace [...]
[...] Purchasing.Vendor Select Table Purchasing.VendorAddress Select Table Purchasing.VendorContact Schema Schema [...]
[...] Sales.CreditCard CreditCardID CreditCardID References Dependency Type Object Type Referenced Object Schema Schema [...]