These functions provide table information including column details and metadata such as commit lag parameters. These functions are particularly useful for checking if tables contain a designated timestamp column.

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 the following columns:

• column - name of the available columns in the table
• type - type of the column
• indexed - if indexing is applied to this column
• indexBlockCapacity - how many row IDs to store in a single storage block on disk
• symbolCached - whether or not this symbol column is cached
• symbolCapacity - how many distinct values this column of symbol type is expected to have
• designated - if this is set as the designated timestamp column for this table

For more details on the meaning and use of these values, see the CREATE TABLE documentation.

Examples:

table_columns('my_table')

SELECT column, type, designated FROM table_columns('my_table') WHERE designated

SELECT type, count() FROM table_columns('my_table');

tables

tables() returns all tables in the database including table metadata.

Arguments:

• tables() does not require arguments.

Return value:

Returns a table.

Examples:

tables();

tables() ORDER BY name DESC;

tables() WHERE partitionBy = 'DAY'