list tables

Prev Next

Function Names

list tables

Description

This funtion lists all existing B4P tables. It is very useful for debugging your code.

Call as: procedure

Restrictions

Indirect parameter passing is disabled

Parameter count

0, 1

Parameters

No.TypeDescription
1
input
string Table search string

The search string narrows down the name of table to be included in the listing. Wildcard symbols are supported here.

Examples

table create ( my table, another table );

table initialize( table with data,
    { { Name,  Favorite Color },
      { Nick },
      { Nicola, Blue },
      { Nicolas, Green, and Yellow } } );

list tables;

echo( new line, "Now list all tables containing 'm' in the name", new line );

list tables('*m*');

// Note: You will also see additional tables like __ excel number formats __ which
// have been created by the library files loaded.

Output

Table Name                            length  # headers  min width  max width
------------------------------------  ------  ---------  ---------  ---------
                            my table       0          0          0          0
                       another table       0          0          0          0
                     table with data       4          2          1          3

Now list all tables containing 'm' in the name

Table Name                            length  # headers  min width  max width
------------------------------------  ------  ---------  ---------  ---------
                            my table       0          0          0          0
Try it yourself: Open LIB_Function_list_tables.b4p in B4P_Examples.zip. Decompress before use.

See also

list variables