Arguments:

• all_tables() does not require arguments.

Return value:

Examples:

• Get all tables in the database

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

• Get all tables in reverse alphabetical order

table_columns

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

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

Return value:

Returns a with two columns:

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

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

• Get the count of column types

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