AdventureWorks2019

Note that there are some explanatory texts on larger screens.

plurals

DLdbo
text
TSQL
copied!ALTER XML SCHEMA COLLECTION [Production].[ProductDescriptionSchemaCollection] ADD '<?xml version="1.0" encoding="UTF-8"?> <xs:schema targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription" elementFormDefault="qualified" xmlns:mstns="http://tempuri.org/XMLSchema.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:wm="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain" > <xs:import namespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain" /> <xs:element name="ProductDescription" type="ProductDescription" /> <xs:complexType name="ProductDescription"> <xs:annotation> <xs:documentation>Product description has a summary blurb, if its manufactured elsewhere it includes a link to the manufacturers site for this component. Then it has optional zero or more sequences of features, pictures, categories and technical specifications. </xs:documentation> </xs:annotation> <xs:sequence> <xs:element name="Summary" type="Summary" minOccurs="0" /> <xs:element name="Manufacturer" type="Manufacturer" minOccurs="0" /> <xs:element name="Features" type="Features" minOccurs="0" maxOccurs="unbounded" /> <xs:element name="Picture" type="Picture" minOccurs="0" maxOccurs="unbounded" /> <xs:element name="Category" type="Category" minOccurs="0" maxOccurs="unbounded" /> <xs:element name="Specifications" type="Specifications" minOccurs="0" maxOccurs="unbounded" /> </xs:sequence> <xs:attribute name="ProductModelID" type="xs:string" /> <xs:attribute name="ProductModelName" type="xs:string" /> </xs:complexType> <xs:complexType name="Summary" mixed="true" > <xs:sequence> <xs:any processContents="skip" namespace="http://www.w3.org/1999/xhtml" minOccurs="0" maxOccurs="unbounded" /> </xs:sequence> </xs:complexType> <xs:complexType name="Manufacturer"> <xs:sequence> <xs:element name="Name" type="xs:string" minOccurs="0" /> <xs:element name="CopyrightURL" type="xs:string" minOccurs="0" /> <xs:element name="Copyright" type="xs:string" minOccurs="0" /> <xs:element name="ProductURL" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> <xs:complexType name="Picture"> <xs:annotation> <xs:documentation>Pictures of the component, some standard sizes are "Large" for zoom in, "Small" for a normal web page and "Thumbnail" for product listing pages.</xs:documentation> </xs:annotation> <xs:sequence> <xs:element name="Name" type="xs:string" minOccurs="0" /> <xs:element name="Angle" type="xs:string" minOccurs="0" /> <xs:element name="Size" type="xs:string" minOccurs="0" /> <xs:element name="ProductPhotoID" type="xs:integer" minOccurs="0" /> </xs:sequence> </xs:complexType> <xs:annotation> <xs:documentation>Features of the component that are more "sales" oriented.</xs:documentation> </xs:annotation> <xs:complexType name="Features" mixed="true" > <xs:sequence> <xs:element ref="wm:Warranty" /> <xs:element ref="wm:Maintenance" /> <xs:any processContents="skip" namespace="##other" minOccurs="0" maxOccurs="unbounded" /> </xs:sequence> </xs:complexType> <xs:complexType name="Specifications" mixed="true"> <xs:annotation> <xs:documentation>A single technical aspect of the component.</xs:documentation> </xs:annotation> <xs:sequence> <xs:any processContents="skip" minOccurs="0" maxOccurs="unbounded" /> </xs:sequence> </xs:complexType> <xs:complexType name="Category"> <xs:annotation> <xs:documentation>A single categorization element that designates a classification taxonomy and a code within that classification type. Optional description for default display if needed.</xs:documentation> </xs:annotation> <xs:sequence> <xs:element ref="Taxonomy" /> <xs:element ref="Code" /> <xs:element ref="Description" minOccurs="0" /> </xs:sequence> </xs:complexType> <xs:element name="Taxonomy" type="xs:string" /> <xs:element name="Code" type="xs:string" /> <xs:element name="Description" type="xs:string" /> </xs:schema>';

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload