Table Info Properties

The following properties are available on TableInfo objects, which appear as expandable sub-properties of the objects that use them.

Misc

Property	Type	Default	Description
Columns	Column[]		The name and type of each column used as a parameter in a SQL statement. The column data type information is only required when the JDBC driver does not make parameter data type information available. The SQL Server JDBC drivers that have been tested provide the parameter data type information, but Oracle and MySQL JDBC drivers do not. If an exception similar to the following is encountered, the column data type information must be defined: Parameter metadata not available for the given statement.
PrimaryKey	PrimaryKey		Specifies the primary key column or columns for the database table that is modified by the Query’s update, insert, and delete SQL statements. The PrimaryKey is only required for a query that is used to update the database.
ProcessGeneratedKeys	bool	true	Controls whether generated keys are processed.

Property

Type

Default

Description

Columns

Column[]

The name and type of each column used as a parameter in a SQL statement.

The column data type information is only required when the JDBC driver does not make parameter data type information available. The SQL Server JDBC drivers that have been tested provide the parameter data type information, but Oracle and MySQL JDBC drivers do not. If an exception similar to the following is encountered, the column data type information must be defined: Parameter metadata not available for the given statement.

PrimaryKey

Specifies the primary key column or columns for the database table that is modified by the Query’s update, insert, and delete SQL statements. The PrimaryKey is only required for a query that is used to update the database.

ProcessGeneratedKeys

bool

true

Controls whether generated keys are processed.