List_Tables routine
Description
Returns the attached tables in the current database.
Syntax
List_Tables(returncolumnlist, sortlist, booleanflaglist)
Parameters
The List_Tables routine has the following parameters.
| Parameter | Description |
|---|---|
| returncolumnlist | Specify 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.) |
| sortlist | Specifies a column name or list of column names to sort by. If null, no sorting takes place. |
| booleanflaglist | If 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.|