How to check the List of columns in a table for particular schema ???

Syed_Mohammad_M

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

[Deleted User]

I believe I've addressed this in response to your other post at https://community.vertica.com/vertica/topics/how_to_check_the_list_of_tables_in_particular_schema_in_hp_vertica Let us know if you have further questions. Adam

Navin_C

Hello Syed, Select column_name from columns where table_name='tableA' and owner_name='syed'; Hope this helps.

Yanxia_Liu

Make that:
select column_name from columns where table_name = 'tableA' and table_schema='syed';

Krishna_Reddy

If I want the entire table structure of a particular table ?

Lokesh_1

Hi Krishna,

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');