system.columns

Advantage SQL Engine

Contains one row for each field of a table in the database.

Field Name	Field Type	Field Size	Description
Name	Character	200	Field name.
Parent	Character	200	Table name the field belongs to.
Field_Num	Integer	4	Position of the field in the table.
Field_Type	ShortInt	2	Numeric representation of the field type.
Field_Length	ShortInt	2	Size of the field in bytes.
Field_Length	Integer	4	Precision of the field.
Field_Min_Value	Memo	variable	The minimum value for the field.
Field_Max_Value	Memo	variable	The maximum value for the field.
Field_Can_Null	Logical	1	Determines if a value must be specified for the field.
Field_Default_Value	Memo	variable	The expression used to generate a default value for the field.
Field_Validation_Msg	Memo	variable	Custom error message displayed when the field does not pass the assigned constraints.
Comment	Memo	variable	Description of the field.
User_Defined_Prop	Binary	variable	The user defined property.

The following table lists values and their meanings for the Field_Type column of system.columns.