AdventureWorks

Basic Index   Expanded Index

Table Name:dbo.AWBuildVersion
Description:Current version number of the AdventureWorks sample database.
Primary Keys:SystemInformationID
FieldTypeDefaultsNulls?Comments
SystemInformationIDtinyint - IdentityNoneNoPrimary key for AWBuildVersion records.
Database Versionnvarchar (25)NoneNoVersion number of the database in 9.yy.mm.dd.00 format.
VersionDatedatetimeNoneNoDate and time the record was last updated.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_AWBuildVersion_SystemInformationIDYesYesSystemInformationID

No check constraints
No internal foreign key constraints
No primary keys as foreign key constraints
No triggers