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:

  • 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.