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





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 


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