Skip to main content

Vertica

  • June 7, 2016
  • 1 reply
  • 7 views
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 

    1 reply

    Adrian_Oprea_1
    Forum|alt.badge.img+1
    • Adrian_Oprea_1
    • Participating Frequently
    • June 8, 2016

     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 ! 

     

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement