Description
Current version number of the AdventureWorks2008 sample database. yay!
Table properties
| name | value |
|---|
| name | [dbo].[AWBuildVersion] |
| created | Mar 19 2009 9:09PM |
| modified | Mar 19 2009 9:09PM
|
| ansi nulls | on
|
| quoted identifier | on
|
| row count | 1 |
| Size of data | 8 kb |
| Size of indexes | 8 kb |
| Maximum size of a single row | 117 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| SystemInformationID | tinyint identity(1,1) | 3 | 1 | | no
| yes
| |
| no
| Primary key for AWBuildVersion records... O RLY? YA RLY!
|
| Database Version | nvarchar(25) | 25 | 100 | | no
|
| |
| no
| Version number of the database in 9.yy.mm.dd.00 format.
|
| VersionDate | datetime | 23 | 8 | | no
|
| |
| no
| Date and time the record was last updated.
|
| ModifiedDate | datetime | 23 | 8 | (getdate()) | no
|
| |
| no
| Date and time the record was last updated.
|
Indexes
| name | description | column | comment |
|---|
| PK_AWBuildVersion_SystemInformationID | clustered, unique, primary key located on PRIMARY | SystemInformationID | Clustered index created by a primary key constraint. Neat!
|
Defaults
Dependency graph
Sample rows
| SystemInformationID | Database Version | VersionDate | ModifiedDate |
|---|
| 1
| 10.00.80404.00
| 4/4/2008 12:00:00 AM
| 4/4/2008 12:00:00 AM
|
Code
CREATE TABLE [dbo].[AWBuildVersion](
[SystemInformationID] [tinyint] IDENTITY(1,1) NOT NULL,
[Database Version] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VersionDate] [datetime] NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
CONSTRAINT [PK_AWBuildVersion_SystemInformationID] PRIMARY KEY CLUSTERED
(
[SystemInformationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[AWBuildVersion] ADD CONSTRAINT [DF_AWBuildVersion_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]