AdventureWorks2019

Search

scanning
Scanning is the default search option for small tables.

Enter text here to perform a scan over supported column types.

Text columns with limited length use a substring search If the entered text is a number, integer columns will be scanned for an exact match of the value.

text to scan for

› search options

seeking
Seeking is the default search option for large tables.

Seeking requires indexes and can only be done using the column (or columns) the index is defined on.

In the single-column case, the database will seek to the position the entered search term would be at and return all rows greater or equal to that value.

In the multiple-column case, the above still applies to the column you supplied non-empty search text for. All previous columns, however, will be using an equality match.

DatabaseLogID

Note that there are some explanatory texts on larger screens.

plurals

DLdbo
primarykey
DatabaseLogID
1
data
PostTime
2017-10-27T14:33:01.390
XmlEvent
text
DatabaseUser
dbo
Event
CREATE_TABLE
Schema
dbo
Object
ErrorLog
TSQL
CREATE TABLE [dbo].[ErrorLog]( [ErrorLogID] [int] IDENTITY (1, 1) NOT NULL, [ErrorTime] [datetime] NOT NULL CONSTRAINT [DF_ErrorLog_ErrorTime] DEFAULT (GETDATE()), [UserName] [sysname] NOT NULL, [ErrorNumber] [int] NOT NULL, [ErrorSeverity] [int] NULL, [ErrorState] [int] NULL, [ErrorProcedure] [nvarchar](126) NULL, [ErrorLine] [int] NULL, [ErrorMessage] [nvarchar](4000) NOT NULL ) ON [PRIMARY]
DLdbo
primarykey
DatabaseLogID
2
data
PostTime
2017-10-27T14:33:01.400
XmlEvent
text
DatabaseUser
dbo
Event
ALTER_TABLE
Schema
dbo
Object
ErrorLog
TSQL
ALTER TABLE [dbo].[ErrorLog] WITH CHECK ADD CONSTRAINT [PK_ErrorLog_ErrorLogID] PRIMARY KEY CLUSTERED ( [ErrorLogID] ) ON [PRIMARY]
DLdbo
primarykey
DatabaseLogID
5
data
PostTime
2017-10-27T14:33:01.417
XmlEvent
text
DatabaseUser
dbo
Event
CREATE_TYPE
Schema
dbo
Object
AccountNumber
TSQL
CREATE TYPE [AccountNumber] FROM nvarchar(15) NULL;
DLdbo
primarykey
DatabaseLogID
6
data
PostTime
2017-10-27T14:33:01.420
XmlEvent
text
DatabaseUser
dbo
Event
CREATE_TYPE
Schema
dbo
Object
Flag
TSQL
CREATE TYPE [Flag] FROM bit NOT NULL;
DLdbo
primarykey
DatabaseLogID
21
data
PostTime
2017-10-27T14:33:01.627
XmlEvent
text
DatabaseUser
dbo
Event
CREATE_XML_SCHEMA_COLLECTION
Schema
HumanResources
Object
HRResumeSchemaCollection
TSQL
CREATE XML SCHEMA COLLECTION [HumanResources].[HRResumeSchemaCollection] AS '<?xml version="1.0" encoding="UTF-8"?> <xsd:schema targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" > <xsd:element name="Resume" type="ResumeType"/> <xsd:element name="Address" type="AddressType"/> <xsd:element name="Education" type="EducationType"/> <xsd:element name="Employment" type="EmploymentType"/> <xsd:element name="Location" type="LocationType"/> <xsd:element name="Name" type="NameType"/> <xsd:element name="Telephone" type="TelephoneType"/> <xsd:complexType name="ResumeType"> <xsd:sequence> <xsd:element ref="Name"/> <xsd:element name="Skills" type="xsd:string" minOccurs="0"/> <xsd:element ref="Employment" maxOccurs="unbounded"/> <xsd:element ref="Education" maxOccurs="unbounded"/> <xsd:element ref="Address" maxOccurs="unbounded"/> <xsd:element ref="Telephone" minOccurs="0"/> <xsd:element name="EMail" type="xsd:string" minOccurs="0"/> <xsd:element name="WebSite" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="AddressType"> <xsd:sequence> <xsd:element name="Addr.Type" type="xsd:string"> <xsd:annotation> <xsd:documentation>Home|Work|Permanent</xsd:documentation> </xsd:annotation> </xsd:element> <xsd:element name="Addr.OrgName" type="xsd:string" minOccurs="0"/> <xsd:element name="Addr.Street" type="xsd:string" maxOccurs="unbounded"/> <xsd:element name="Addr.Location"> <xsd:complexType> <xsd:sequence> <xsd:element ref="Location"/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="Addr.PostalCode" type="xsd:string"/> <xsd:element name="Addr.Telephone" minOccurs="0"> <xsd:complexType> <xsd:sequence> <xsd:element ref="Telephone" maxOccurs="unbounded"/> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> <xsd:complexType name="EducationType"> <xsd:sequence> <xsd:element name="Edu.Level" type="xsd:string"> <xsd:annotation> <xsd:documentation>High School|Associate|Bachelor|Master|Doctorate</xsd:documentation> </xsd:annotation> </xsd:element> <xsd:element name="Edu.StartDate" type="xsd:date"/> <xsd:element name="Edu.EndDate" type="xsd:date"/> <xsd:element name="Edu.Degree" type="xsd:string" minOccurs="0"/> <xsd:element name="Edu.Major" type="xsd:string" minOccurs="0"/> <xsd:element name="Edu.Minor" type="xsd:string" minOccurs="0"/> <xsd:element name="Edu.GPA" type="xsd:string" minOccurs="0"/> <xsd:element name="Edu.GPAAlternate" type="xsd:decimal" minOccurs="0"> <xsd:annotation> <xsd:documentation>In case the institution does not follow a GPA system</xsd:documentation> </xsd:annotation> </xsd:element> <xsd:element name="Edu.GPAScale" type="xsd:decimal" minOccurs="0"/> <xsd:element name="Edu.School" type="xsd:string" minOccurs="0"/> <xsd:element name="Edu.Location" minOccurs="0"> <xsd:complexType> <xsd:sequence> <xsd:element ref="Location"/> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> <xsd:complexType name="EmploymentType"> <xsd:sequence> <xsd:element name="Emp.StartDate" type="xsd:date" minOccurs="0"/> <xsd:element name="Emp.EndDate" type="xsd:date" minOccurs="0"/> <xsd:element name="Emp.OrgName" type="xsd:string"/> <xsd:element name="Emp.JobTitle" type="xsd:string"/> <xsd:element name="Emp.Responsibility" type="xsd:string"/> <xsd:element name="Emp.FunctionCategory" type="xsd:string" minOccurs="0"/> <xsd:element name="Emp.IndustryCategory" type="xsd:string" minOccurs="0"/> <xsd:element name="Emp.Location" minOccurs="0"> <xsd:complexType> <xsd:sequence> <xsd:element ref="Location"/> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> <xsd:complexType name="LocationType"> <xsd:sequence> <xsd:element name="Loc.CountryRegion" type="xsd:string"> <xsd:annotation> <xsd:documentation>ISO 3166 Country Code</xsd:documentation> </xsd:annotation> </xsd:element> <xsd:element name="Loc.State" type="xsd:string" minOccurs="0"/> <xsd:element name="Loc.City" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="NameType"> <xsd:sequence> <xsd:element name="Name.Prefix" type="xsd:string" minOccurs="0"/> <xsd:element name="Name.First" type="xsd:string"/> <xsd:element name="Name.Middle" type="xsd:string" minOccurs="0"/> <xsd:element name="Name.Last" type="xsd:string"/> <xsd:element name="Name.Suffix" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="TelephoneType"> <xsd:sequence> <xsd:element name="Tel.Type" minOccurs="0"> <xsd:annotation> <xsd:documentation>Voice|Fax|Pager</xsd:documentation> </xsd:annotation> </xsd:element> <xsd:element name="Tel.IntlCode" type="xsd:int" minOccurs="0"/> <xsd:element name="Tel.AreaCode" type="xsd:int" minOccurs="0"/> <xsd:element name="Tel.Number" type="xsd:string"/> <xsd:element name="Tel.Extension" type="xsd:int" minOccurs="0"/> </xsd:sequence> </xsd:complexType> </xsd:schema>';
DLdbo
primarykey
DatabaseLogID
23
data
PostTime
2017-10-27T14:33:01.657
XmlEvent
text
DatabaseUser
dbo
Event
ALTER_XML_SCHEMA_COLLECTION
Schema
Production
Object
ProductDescriptionSchemaCollection
TSQL
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>';
DLdbo
primarykey
DatabaseLogID
3
data
PostTime
2017-10-27T14:33:01.403
XmlEvent
text
DatabaseUser
dbo
Event
CREATE_PROCEDURE
Schema
dbo
Object
uspPrintError
TSQL
-- uspPrintError prints error information about the error that caused -- execution to jump to the CATCH block of a TRY...CATCH construct. -- Should be executed from within the scope of a CATCH block otherwise -- it will return without printing any error information. CREATE PROCEDURE [dbo].[uspPrintError] AS BEGIN SET NOCOUNT ON; -- Print error information. PRINT 'Error ' + CONVERT(varchar(50), ERROR_NUMBER()) + ', Severity ' + CONVERT(varchar(5), ERROR_SEVERITY()) + ', State ' + CONVERT(varchar(5), ERROR_STATE()) + ', Procedure ' + ISNULL(ERROR_PROCEDURE(), '-') + ', Line ' + CONVERT(varchar(5), ERROR_LINE()); PRINT ERROR_MESSAGE(); END;
DLdbo
primarykey
DatabaseLogID
7
data
PostTime
2017-10-27T14:33:01.420
XmlEvent
text
DatabaseUser
dbo
Event
CREATE_TYPE
Schema
dbo
Object
NameStyle
TSQL
CREATE TYPE [NameStyle] FROM bit NOT NULL;
DLdbo
primarykey
DatabaseLogID
8
data
PostTime
2017-10-27T14:33:01.420
XmlEvent
text
DatabaseUser
dbo
Event
CREATE_TYPE
Schema
dbo
Object
Name
TSQL
CREATE TYPE [Name] FROM nvarchar(50) NULL;

...and more

Querying!

Guidance

A table list

Lists show table rows with slightly less information than detail views, therefore not requiring section labels.

This list shows the beginning of an entire table.

Search

Searching on lists works via indexes when the table is large. On the left you see input fields generated from viable indexes and an expandable report for all indexes that are unavailable for searching with the respective reasons.

Searching along indexes is called seeking and this is one of the main values that databases offer. The trivial alternative is scanning, which is potentially inefficient as it works by walking the entirety of the candidate rows to find the matches.

The offer to scan is given for small tables. Currently, this only works on text and integer columns and they are searched all at once.

Loading more

Loading more rows than the initial 10 results is also currently restricted to a single reloading of 100 entries.

A future version will keep auto-loading on scroll for tables that have suitable indexes.

Search

scanning Scanning is the default search option for small tables. Enter text here to perform a scan over supported column types. Text columns with limited length use a substring search If the entered text is a number, integer columns will be scanned for an exact match of the value.

Querying!

Guidance

A table list

Search

Loading more

scanning
Scanning is the default search option for small tables.

Enter text here to perform a scan over supported column types.

Text columns with limited length use a substring search If the entered text is a number, integer columns will be scanned for an exact match of the value.