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

Syed_Mohammad_M

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'

[Deleted User]

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

Navin_C

Hello Syed, Select table_name from tables where owner_name='syed'; OR \dt

saumya_tamma

Hi,

You can use the following

select table_name from tables where table_schema='syed'

thanks
Saumya