SchemaTable Class

The SchemaTable class provides a description of a DATA-QWIK table. An instance of this class is returned by Db.getSchemaTable().

The table below describes the properties of a SchemaTable class instance. All properties are of type String, unless explicitly noted otherwise.

Ancestor	Reference
Descendants	None

Properties	Description
columnDelimiter	ASCII code of character that delimits column values (type Number).
count	Total number of columns (type Number).
database	Database type (e.g., "Vendor").
dataType	String that contains all different datatypes used by this table.
dateCreated	Date when the table was created (type Date).
dateUpdated	Date when the table definition was last updated (type Date).
defaultList	List of columns with a default value (type List).
description	Description of the table.
existsNode	Record exists node reference.
filerPGM	Name of the filer routine.
global	Name of the M global where the data for this table is stored.
hasBlob	Boolean that indicates whether the table includes columns with datatype Blob (type Boolean).
hasMemo	Boolean that indicates whether the table includes columns with datatype Memo (type Boolean).
hasSubfield	Boolean that indicates whether the table includes columns that use subfields (type Boolean).
isAutoLog	Boolean that indicates whether automatic change logging is enabled for this table (type Boolean).
parentTable	Name of the parent table (if any).
primaryKeys	List of primary keys.
publishPGM	Name of the update publish routine.
recordType	Internal record type (e.g., 0, 10, 11, type Number).
requiredList	List of required columns (i.e., columns with a NOT NULL constraint) (type List)
systemName	The system name associated with the file.
table	Name of the table.
timeCreated	Time the table definition was created (type Time).
timeUpdated	Time the table definition was last modified (type Time).
userCreated	Name of the user that created the table definition.
userUpdated	Name of the user that made the last modification to the table definition.
verifyPGM	Name of the verification routine (used to verify access to column values of the table).
Methods	Description
None