Limited Access to System Tables
The majority of Vertica’s system tables from V_MONITORING and V_CATALOG schemata for introspecting your logical (tables) and physical (projections) data model in Data Warehouse are accessible.
You can access the available system tables only without the schema quantifier:
- SELECT * FROM tables – works
- SELECT * FROM v_catalog.tables – does not work
You can access the following tables:
Any table that is not in the following list is not accessible.
- all_tables
- column_storage
- columns
- comments
- constraint_columns
- current_session
- delete_vectors
- deploy_status
- deployment_projection_statements
- deployment_projections
- design_queries
- design_status
- design_tables
- designs
- dual
- epochs
- error_messages
- execution_engine_profiles
- foreign_keys
- grants
- license_audits
- load_streams
- lock_usage
- locks
- merge_streams
- configuration_changes
- odbc_columns
- output_deployment_status
- output_event_history
- output_query_plan_costs
- partition_columns
- partition_reorganize_errors
- partition_status
- partitions
- passwords
- primary_keys
- projection_checkpoint_epochs
- projection_columns
- projection_delete_concerns
- projection_recoveries
- projection_refreshes
- projection_storage
- projection_usage
- projections
- query_events
- query_plan_profiles
- query_profiles
- query_requests
- resource_acquisitions
- resource_pool_defaults
- resource_pool_move
- resource_pool_status
- resource_pools
- resource_queues
- resource_rejection_details
- resource_rejections
- roles
- sequences
- session_profiles
- sessions
- storage_containers
- strata
- strata_structures
- system_columns
- system_sessions
- system_tables
- table_constraints
- tables
- transactions
- tuple_mover_operations
- types
- user_audits
- user_functions
- user_libraries
- user_library_manifest
- user_procedures
- user_sessions
- user_transforms
- view_columns
- views
For the full list and the documentation of individual system tables, see Vertica System Tables.