Comments

• [Deleted User] ✭

  November 2014

  It is just columns table no system columns. 
  Eugenia 

  0
• knicely87

  November 2014

  Maybe try ilike if you are using mix case?
  
  dbadmin=> select column_name, data_type from system_columns where table_name ilike '%system_columns%';
         column_name        |   data_type   
  --------------------------+----------------
   table_id                 | int
   table_schema             | varchar(128)
   table_name               | varchar(128)
   is_system_table          | boolean
   column_id                | varchar(41)
   column_name              | varchar(128)
   data_type                | varchar(128)
   data_type_id             | int
   data_type_length         | int
   character_maximum_length | int
   numeric_precision        | int
   numeric_scale            | int
   datetime_precision       | int
   interval_precision       | int
   ordinal_position         | int
   is_nullable              | boolean
   column_default           | varchar(65000)
  (17 rows)

  0
• Navin_C Vertica Customer ✭

  November 2014

  If using Dbvisualizer, you can follow these steps
  
  Right Click on table --> Select "Script as" option --> select "CREATE" Radio option --> Create table script created for you.
  
  OR, you can use this query to get all details that you would get using describe table

  select distinct t.table_schema,t.table_name, c.ordinal_position, c.column_name, c.data_type, c.is_nullable , c.is_identity, con.constraint_name,con.constraint_type  from  columns c   left join tables t on t.table_schema = c.table_schema and t.table_name = 'table_name'  left join constraint_columns con on t.table_name = con.table_name and c.column_name = con.column_name and constraint_type='p'  where c.table_schema = 'schema_name' and c.table_name = 'table_name'  order by ordinal_position

  Hope this helps
  NC

  0
• Abhishek_Rana Vertica Employee Employee

  November 2014

  An easy & one more way to do it in VSQL is :
  
  \d <table_name>
  

  0
• SaifMasadeh

  September 2015

  Use the command below :

   

  \d table_name

   

  Schema |     Table      |        Column        |     Type      | Size |             Default              | Not Null | Primary Key | Foreign Key
  --------+----------------+----------------------+---------------+------+----------------------------------+----------+-------------+-------------
   
  

  0
• virendhar

  March 2018 edited March 2018

  \d table_name
  \dv view_name
  \dt table_name --> table high level details

  0