dbo.AWBuildVersion
| Documentation | AdventureWorks |
| Schema | dbo |
| Name | AWBuildVersion |
| Module | Admin |
Current version number of the AdventureWorks 2012 sample database.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | SystemInformationID | tinyint | Identity | Primary key for AWBuildVersion records. | ||||
| Primary key for AWBuildVersion records. Identity |
||||||||
| 2 | Database Version | nvarchar(25) | Version number of the database in 9.yy.mm.dd.00 format. | |||||
| Version number of the database in 9.yy.mm.dd.00 format. |
||||||||
| 3 | VersionDate | datetime | Date and time the record was last updated. | |||||
| Date and time the record was last updated. |
||||||||
| 4 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
| Date and time the record was last updated. Default: getdate() |
||||||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_AWBuildVersion_SystemInformationID | SystemInformationID | Primary key (clustered) constraint | |
| Primary key (clustered) constraint | |||
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56