all_tables

all_tables() returns all tables in the database.

Arguments:

• all_tables() does not require arguments.

Return value:

Returns a table.

Examples:

• Get all tables in the database

all_tables();

• Get all tables in the database that match ‘sales’

all_tables() WHERE tableName ~= 'sales';

• Get all tables in reverse alphabetical order

all_tables() ORDER BY tableName DESC;

table_columns

table_columns('tableName') returns the schema of a table

Arguments:

• tableName is the name of an existing table as a string

Return value:

Returns a table with two columns:

• columnName - name of the available columns in the table
• columnType - type of the column

Examples:

• Get all columns in the table

table_columns('myTable')

• Get all columns in the database that match the name ‘sales’

SELECT columnName FROM table_columns('myTable') WHERE columnName ~= 'sales';

• Get the count of column types

SELECT columnType, count() FROM table_columns('wthr');