Product Logo

CNS Query

Query your databases without relationships.

Script Steps

CNS Query Get Field Types

NameCNS Query Get Field Types

Returns either the field type of a specific field or a list of “FieldName=FieldType” pairs for all fields in a table.

FormatCNS Query Get Field Types ( Select entire contents ; Target ; File Name ; Table Name ; Field Name )
Optional Parameters
Select entire contents

If checked, the target field or variable will be replaced by the result of this script step.


Specify the field or variable to receive the file path.

File Name

The database file name.

Table Name

The name of the table occurrence that contains the field[s].

Field Name

If you only want the type of one field, specify its name here. [Default is to return the types of all fields.]