GetTablesAndKeys method

Overview

Returns:

Name	Description	Type
qWindowSize	Defines the size of the window that is used to display the results.	Size
qNullSize		Size
qCellHeight	Height of a cell in a table in pixels.	Integer
qSyntheticMode	One of: true for internal table viewer false for source table viewer This parameter is mandatory.	Boolean
qIncludeSysVars	If set to true, the system variables are included.	Boolean

Name	Description	Type
qcx	Number of pixels on the x axis.	Integer
qcy	Number of pixels on the y axis.	Integer

The following is returned in the output:

Name	Description	Type
qtr	List of tables.	Array of TableRecord
qk	List of keys.	Array of SourceKeyRecord

Name	Description	Type
qName	Name of the table.	String
qLoose	This property is set to true if the table is loose.	Boolean
qNoOfRows	Number of rows in the table.	Integer
qFields	Information about the fields in the table.	Array of FieldInTableData.
qPos	Information about the position of the table.	Point
qComment	Comment related to the table.	String
qIsDirectDiscovery	If set to true, Direct Discovery is used. Direct Discovery fields are not loaded into memory and remain in the external database.	Boolean
qIsSynthetic	This property is set to true if the table contains a synthetic key.	Boolean

Name	Description	Type
qName	Name of the field.	String
qOriginalFields	Is shown for fixed records. qOriginalFieldName and qName are identical if no field names are used in the file. qOriginalFieldName differs from qName if embedded file names are used in the file.	Array of String
qPresent		Boolean
qHasNull	This property is set to true if the field contains some Null values.	Boolean
qHasWild		Boolean
qHasDuplicates	This property is set to true if the field contains some duplicate values.	Boolean
qIsSynthetic	This property is set to true if the field contains a synthetic key.	Boolean
qInformationDensity	Number of records that have values (i.e. not NULL) in the field as compared to the total number of records in the table.	Double
qnNonNulls	Number of values that are non Null.	Integer
qnRows	Number of rows in the field	Integer
qSubsetRatio	Number of distinct values in the field (in the current table) as compared to the total number of distinct values of this field (in all tables).	Double
qnTotalDistinctValues	Number of distinct values in the field.	Integer
qnPresentDistinctValues		Integer
qKeyType	Tells if the field is a key field.	One of: NOT_KEY ANY_KEY PRIMARY_KEY PERFECT_KEY
qComment	Comment related to the field.	String
qTags	List of tags related to the field.	Array of String
qDerivedFields	List of the derived fields.	Array of DerivedFieldsInTableData.

Name	Description	Type
qDefinitionName	Name of the derived definition.	String
qTags	List of tags.	Array of String
qActive	Is set to true is the derived field is in use.	Boolean

Name	Description	Type
qx	x-coordinate in pixels. The origin is the top left of the screen.	Integer
qy	y-coordinate in pixels. The origin is the top left of the screen.	Integer

Name

Description

Type

x-coordinate in pixels.

The origin is the top left of the screen.

Integer

y-coordinate in pixels.

The origin is the top left of the screen.

Integer

Name	Description	Type
qKeyFields	Name of the key field.	Array of String
qTables	Table the key belongs to.	Array of String

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!