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 columns in a table for particular schema ???
How to check the List of columns in a table for particular schema ??? The below Oracle query is not working with HP Vertica: select COLUMN_NAME from ALL_TAB_COLUMNS where table_name= and owner= Vertica is not giving support for ALL_TAB_COLUMNS
0
Comments
select column_name from columns where table_name = 'tableA' and table_schema='syed';
You can use below for vsql.
\d tables_schema.table_name
you can get ddl of a table using
select export_objects('','table_schema.table_name');