ALL_TABLES
Provides summary information about tables in a Vertica database.
Column Name | Data Type | Description |
---|---|---|
SCHEMA_NAME |
VARCHAR |
The name of the schema that contains the table. |
TABLE_ID |
INTEGER |
A unique numeric ID assigned by the Vertica catalog that identifies the table. |
TABLE_NAME |
VARCHAR |
The table name. |
TABLE_TYPE |
VARCHAR |
The type of table, which can be one of the following:
|
REMARKS |
VARCHAR |
A brief comment about the table. You define this field by using the COMMENT ON TABLE and COMMENT ON VIEW commands. |
Example
onenode=> SELECT DISTINCT table_name, table_type FROM all_tables WHERE table_name ILIKE 't%'; table_name | table_type ------------------------+-------------- types | SYSTEM TABLE trades | TABLE tuple_mover_operations | SYSTEM TABLE tables | SYSTEM TABLE tuning_recommendations | SYSTEM TABLE testid | TABLE table_constraints | SYSTEM TABLE transactions | SYSTEM TABLE (8 rows) onenode=> SELECT table_name, table_type FROM all_tables WHERE table_name ILIKE 'my%'; table_name | table_type ------------+------------ mystocks | VIEW (1 row) => SELECT * FROM all_tables LIMIT 4; -[ RECORD 1 ]------------------------------------------- schema_name | v_catalog table_id | 10206 table_name | all_tables table_type | SYSTEM TABLE remarks | A complete listing of all tables and views -[ RECORD 2 ]------------------------------------------- schema_name | v_catalog table_id | 10000 table_name | columns table_type | SYSTEM TABLE remarks | Table column information -[ RECORD 3 ]------------------------------------------- schema_name | v_catalog table_id | 10054 table_name | comments table_type | SYSTEM TABLE remarks | User comments on catalog objects -[ RECORD 4 ]------------------------------------------- schema_name | v_catalog table_id | 10134 table_name | constraint_columns table_type | SYSTEM TABLE remarks | Table column constraint information