1 dbo Move the mouse over tables & columns to read the comments. AWBuildVersionTable dbo.AWBuildVersion Current version number of the AdventureWorks 2016 sample database. Pk PK_AWBuildVersion_SystemInformationID ( SystemInformationID ) Clustered index created by a primary key constraint. SystemInformationIDtinyintSystemInformationID * tinyint Primary key for AWBuildVersion records. # Database Versionnvarchar(25)Database Version * nvarchar(25) Version number of the database in 9.yy.mm.dd.00 format. t VersionDatedatetimeVersionDate * datetime Date and time the record was last updated. d ModifiedDatedatetimeModifiedDate * datetime default getdate() Date and time the record was last updated. d ErrorLogTable dbo.ErrorLog Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct. Pk PK_ErrorLog_ErrorLogID ( ErrorLogID ) Clustered index created by a primary key constraint. ErrorLogIDintErrorLogID * int Primary key for ErrorLog records. # ErrorTimedatetimeErrorTime * datetime default getdate() The date and time at which the error occurred. d UserNamesysnameUserName * sysname The user who executed the batch in which the error occurred. t ErrorNumberintErrorNumber * int The error number of the error that occurred. # ErrorSeverityintErrorSeverity int The severity of the error that occurred. # ErrorStateintErrorState int The state number of the error that occurred. # ErrorProcedurenvarchar(126)ErrorProcedure nvarchar(126) The name of the stored procedure or trigger where the error occurred. t ErrorLineintErrorLine int The line number at which the error occurred. # ErrorMessagenvarchar(4000)ErrorMessage * nvarchar(4000) The message text of the error that occurred. t DatabaseLogTable dbo.DatabaseLog Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. Pk PK_DatabaseLog_DatabaseLogID ( DatabaseLogID ) Nonclustered index created by a primary key constraint. DatabaseLogIDintDatabaseLogID * int Primary key for DatabaseLog records. # PostTimedatetimePostTime * datetime The date and time the DDL change occurred. d DatabaseUsersysnameDatabaseUser * sysname The user who implemented the DDL change. t EventsysnameEvent * sysname The type of DDL statement that was executed. t SchemasysnameSchema sysname The schema to which the changed object belongs. t ObjectsysnameObject sysname The object that was changed by the DDL statment. t TSQLnvarchar(max)TSQL * nvarchar(max) The exact Transact-SQL statement that was executed. t XmlEventxmlXmlEvent * xml The raw XML data generated by database trigger. t


Table AWBuildVersion

Current version number of the AdventureWorks 2016 sample database.

IndexesField NameData TypeDescription
* SystemInformationID tinyint AUTOINCREMENT Primary key for AWBuildVersion records.
* Database Version nvarchar( 25 ) Version number of the database in 9.yy.mm.dd.00 format.
* VersionDate datetime Date and time the record was last updated.
* ModifiedDate datetime DEFAULT getdate() Date and time the record was last updated.
Indexes
PK_AWBuildVersion_SystemInformationID ON SystemInformationID Clustered index created by a primary key constraint.


Table DatabaseLog

Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.

IndexesField NameData TypeDescription
* DatabaseLogID int AUTOINCREMENT Primary key for DatabaseLog records.
* PostTime datetime The date and time the DDL change occurred.
* DatabaseUser sysname The user who implemented the DDL change.
* Event sysname The type of DDL statement that was executed.
  Schema sysname The schema to which the changed object belongs.
  Object sysname The object that was changed by the DDL statment.
* TSQL nvarchar(max) The exact Transact-SQL statement that was executed.
* XmlEvent xml The raw XML data generated by database trigger.
Indexes
PK_DatabaseLog_DatabaseLogID ON DatabaseLogID Nonclustered index created by a primary key constraint.


Table ErrorLog

Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.

IndexesField NameData TypeDescription
* ErrorLogID int AUTOINCREMENT Primary key for ErrorLog records.
* ErrorTime datetime DEFAULT getdate() The date and time at which the error occurred.
* UserName sysname The user who executed the batch in which the error occurred.
* ErrorNumber int The error number of the error that occurred.
  ErrorSeverity int The severity of the error that occurred.
  ErrorState int The state number of the error that occurred.
  ErrorProcedure nvarchar( 126 ) The name of the stored procedure or trigger where the error occurred.
  ErrorLine int The line number at which the error occurred.
* ErrorMessage nvarchar( 4000 ) The message text of the error that occurred.
Indexes
PK_ErrorLog_ErrorLogID ON ErrorLogID Clustered index created by a primary key constraint.

Powered by DbSchema