Navigation:  Advantage SQL > System Views > Views >

system.columns

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

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

Integer

4

Size of the field in bytes.

Field_Decimal

ShortInt

2

Precision of the field.

Field_Min_Value

NMemo

variable

The minimum value for the field.

Field_Max_Value

NMemo

variable

The maximum value for the field.

Field_Can_Be_Null

Logical

1

Determines if a value must be specified for the field.

Field_Default_Value

NMemo

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.

Field_Options

Integer

4

A bitmask of field options. Possible values include ADS_DD_FIELD_OPT_VFP_BINARY (indicates it is a VFP field created with the NOCPTRANS option), and ADS_DD_FIELD_OPT_VFP_NULLABLE (indicates it is a nullable VFP field).

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

LongInt

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.

23

VarCharFox

Available in ADT and VFP tables

24

VarBinaryFox

Available in ADT and VFP tables

25

System Field

Internal use only

26

NChar

 

27

NVarChar

 

28

NMemo

 

29

GUID

 

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