The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to check the List of Tables in particular schema in HP Vertica ???

How to check the List of Tables in particular schema in HP Vertica ??? The below Oracle query is not working with HP Vertica: SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER='VMartDB'


  • Hi Syed, Vertica supports standard SQL but does not necessarily provide the same system tables as any particular other database. Vertica's system tables are listed in our documentation. Here's a direct link: In particular, you probably want to select from "TABLES", rather than "ALL_TABLES". Or "COLUMNS", rather than "ALL_TAB_COLUMNS", per your other recent post. As Ravi noted in a third one of your posts, we also support a bunch of vsql shortcuts for accessing this sort of information. You can see the full list of shortcuts by typing "\?" at a vsql prompt. These only work in vsql; if you're using ODBC/JDBC/etc, you'll have to use the system tables above. It sounds like you're generally new to Vertica? We are very similar to other SQL databases in some ways, but not identical. Some of our training courses might help you to understand the differences; see: Adam
  • Navin_CNavin_C Vertica Customer
    Hello Syed, Select table_name from tables where owner_name='syed'; OR \dt
  • Hi,

    You can use the following

    select table_name from tables where table_schema='syed'


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file