You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.
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.