The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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'

Comments

  • 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: https://my.vertica.com/docs/6.1.x/HTML/index.htm#12288.htm 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: http://www.vertica.com/customer-experience/12573-2/ Adam
  • 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'

    thanks
    Saumya

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.