Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica

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 

Comments

  •  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 ! 

     

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.