AdventureWorks
| Table Name: | dbo.AWBuildVersion |
| Description: | Current version number of the AdventureWorks sample database. |
| Primary Keys: | SystemInformationID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| SystemInformationID | tinyint - Identity | None | No | Primary key for AWBuildVersion records. |
| Database Version | nvarchar (25) | None | No | Version number of the database in 9.yy.mm.dd.00 format. |
| VersionDate | datetime | None | No | Date and time the record was last updated. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_AWBuildVersion_SystemInformationID | Yes | Yes | SystemInformationID |