Vertica

Ardy

Show table   RETAIL_APP.RTL_TLD_PROD_HIER;

 

 

This is my quiery  in TeraData and i am using SQL workbench and i want to execute the same on Vertica end to have the table validations from TeraData and Vertica so can some one help me what do i need to use in place of " Show table " to execute it on vertica end .

 

I just need the quiery 

Adrian_Oprea_1

 Hi Ardy, 

 

To see the schelet of your table/view use the \d vsql command line option followed by the object name 

See example : 

dbadmin=> \d public.test_load
                                  List of Fields by Tables
 Schema |   Table   | Column | Type | Size | Default | Not Null | Primary Key | Foreign Key
--------+-----------+--------+------+------+---------+----------+-------------+-------------
 public | test_load | id     | int  |    8 |         | f        | f           |
(1 row)

i hope this was helpful !