Description

Returns the attached tables in the current database.

Syntax

List_Tables(returncolumnlist, sortlist, booleanflaglist)

Parameters

The List_Tables routine has the following parameters.

ParameterDescription
returncolumnlistSpecify a column name or list of columns names to return. Column names are defined in DICT.SYSTABLES. If returncolumnlist is null, the column TABLE_NAME is returned by default. Valid DICT.SYSTABLES column names are:

BFS

DATABASE_ID

FS_LIST

HANDLE

TABLE_NAME (default)

VOLUME_NAME

System tables are not included. (Refer to booleanflaglist, below.)

sortlistSpecifies a column name or list of column names to sort by. If null, no sorting takes place.
booleanflaglistIf booleanflaglist is true (1), then the system tables are included in the list of tables.

In BASIC+, the list of tables is stored in the system global variable @tables. Specific table information can be selected and/or read from the SYSTABLES table.

  • No labels