Codes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CodeId uniqueidentifier 16 null
CodeValues.CodeId CodeValues_Codes_ForeignKey C
qryCodeValues.CodeId Implied Constraint R
CodeNo int 4 null
Code nvarchar 100 null
External nvarchar 100 null
Description nvarchar 100 null
XTable nvarchar 100 null
XField nvarchar 100 null

Table contained 30 rows

Indexes

Constraint Name Type Sort Column(s)
Codes_PrimaryKey Primary key Asc CodeId
Codes_CodeId_Index Performance Asc CodeId

Relationships