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.

Value

Field

Notes

1

Logical

 

2

Numeric

 

3

Date

 

4

String

 

5

Memo

 

6

Binary

 

7

Image

 

8

Varchar

Deprecated

9

Compactdate

Available only in DBF tables.

10

Double

 

11

Integer

 

12

ShortInt

Available only in ADT tables.

13

Time

Available only in ADT tables.

14

TimeStamp

Available only in ADT tables.

15

AutoInc

Available only in ADT tables.

16

Raw

Available only in ADT tables.

17

CurDouble

Available only in ADT tables.

18

Money

Available only in ADT tables.

19

LongLong

Available only in ADT tables.

20

CIString

Available only in ADT tables.

21

RowVersion

Available only in ADT tables.

22

ModTime

Available only in ADT tables.

For more information about field types see ADT Field Types and Specifications or DBF Field Types and Specifications.