SQLListTable (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / SQL functions

Tip: How can I speed up the execution time of the SQLListTable function?

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLListTable (Function)

In french: SQLListeTable

List all the tables that can be accessed by the connected database system.

Example

// Liste non détaillée des tables
Ch is string = SQLListTable(False)
Ch = NoSpace(Ch)
// Ajout dans un champ Liste
ListAdd(LISTE_ListeTable, Ch)

// Liste détaillée
Ch is string = SQLListTable()
Ch = NoSpace(Ch)
// Ajout dans un champ Table
TableAdd(TABLE_TABSOURCE, Ch)

Ch is string = SQLListTable()
Ch = NoSpace(Ch)
// Traite la première ligne renvoyée
Ch = ExtractString(Ch, 1, CR)
// Extraire le nom de la table
Nom = ExtractString(Ch, 1)
// Extraire le qualifiant
Qual = ExtractString(Ch, 2)
// Extraire le propriétaire
Prop = ExtractString(Ch, 3)
// Extraire le type de la table
Type = ExtractString(Ch, 4)

Syntax

<Result> = SQLListTable([<Detailed list> [, <Elements to List>]])

<Result>: Character string

Characteristics (detailed or not) of each element listed for the current connection. These characteristics can be inserted into a list box by ListAdd.
Detailed characteristics:
<Name of table> + TAB + <Qualifier> + TAB + <Owner of table> +
TAB + <Type of table> + CR + <Name of table 2> + TAB + <Qualifier 2> +
TAB + <Owner of table 2> + <Type of table 2> + CR +...
Non-detailed characteristics:
<Name of Table 1> + CR + <Name of Table 2> + CR +...
Only the non-detailed characteristics of each element are listed.
The qualifier and the owner of the table are not displayed.

<Detailed list>: Optional boolean

True (default) to get a detailed list,
False to get a non-detailed list.
Only the non-detailed characteristics of each element are listed.

<Elements to List>: Optional boolean

True to list the tables and the views,
False (default) to list:
by an OLE DB provider: tables, views and system tables
via an ODBC driver: tables, views, system tables, aliases, etc. Warning: this operation can be very slow, for example when accessing Oracle via ODBC, as the ORACLE database has a large number of tables.

Remarks

Tip: How can I speed up the execution time of the SQLListTable function?

The following syntax is recommended:

SQLListTable(False, True)

The second parameter to True indicates that temporary tables, systems, aliases, etc. should not be listed.

Component: wd300hf.dll