List_Tables routine [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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.|

**\\
**