Table: 'dbo.AWBuildVersion'

4 fields. 83 bytes.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
SystemInformationIDtinyint identity tinyint Not nullPrimary key for AWBuildVersion records. 
Database Versionnvarchar25  Not nullVersion number of the database in 9.yy.mm.dd.00 format. 
VersionDatedatetime   Not nullDate and time the record was last updated. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'dbo.AWBuildVersion'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'dbo.AWBuildVersion', 1 item

Index NameDescriptionClusteredUniqueFields
PK_AWBuildVersion_SystemInformationIDClustered index created by a primary key constraint.YesYesSystemInformationID

Triggers for table 'dbo.AWBuildVersion', 1 item

uAWBuildVersionAFTER UPDATE trigger setting the ModifiedDate column in the AWBuildVersion table to the current date.after Update Yes

Dependencies for table 'dbo.AWBuildVersion', 1 item

Object NameTypeField Name