AX1639

GetTableInfo function

Returns information about a table, given the table name.

Syntax

GetTableInfo("CodeName", "TableName")

Parameter Description

CodeName

Specifies the table property to return. Use one of the following values:

  • Classification: Returns the table classification for the table, such as Data or Reference.

  • IndexScheme: Returns the index scheme for the table, such as Default or Large Table.

  • IsReadOnly: Returns whether the table is read-only (True/False).

  • TableType: Returns the table type that the table is assigned to (blank if the table is not assigned to a table type).

The following options only apply to product systems, and are configured by product development and implementation consultants:

  • CustomerTableName: Returns the real name of the table.

  • IsVariable: Returns whether the table is flagged as variable (True/False).

  • PreferredName: Returns the preferred name of the table.

TableName

The name of the table for which you want to return information.

All non-numeric entries must be placed in double quotation marks, unless you are using cell references to reference the text held in another cell.

Remarks

GetTableInfo is a non-volatile function.

Examples

=GetTableInfo("Classification","Dept")

This example returns the table classification of Dept. For example: Reference.

=GetTableInfo("TableType","GL2019")

This example returns the table type that the table is assigned to. For example: GLData.