dbo.AWBuildVersion

Table: 'dbo.AWBuildVersion'

4 fields. 83 bytes.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
SystemInformationID	tinyint identity		tinyint		Not null	Primary key for AWBuildVersion records.
Database Version	nvarchar	25			Not null	Version number of the database in 9.yy.mm.dd.00 format.
VersionDate	datetime				Not null	Date and time the record was last updated.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'dbo.AWBuildVersion'

Primary Key Name	Field Name
PK_AWBuildVersion_SystemInformationID	SystemInformationID

There are no Foreign Keys for this table.

Indexes for table 'dbo.AWBuildVersion', 1 item

Index Name	Description	Clustered	Unique	Fields
PK_AWBuildVersion_SystemInformationID	Clustered index created by a primary key constraint.	Yes	Yes	SystemInformationID

Triggers for table 'dbo.AWBuildVersion', 1 item

Name	Description	Type	Enabled
uAWBuildVersion	AFTER 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 Name	Type	Field Name
dbo.uAWBuildVersion	trigger	N/A