Comments

• Abhishek_Rana Vertica Employee Employee

  March 2014

  Hi,
  
  There is no SHOW command in vertica , but to get what you required you can use below:
  
  EXPORT_OBJECTS( '/tmp/design.sql', 'object_name');
  
  Here object_name can be replaced with schema_name.table_name
  
  And
  
  /tmp/design.sql will be the file, where DDl for this object can be found
  
  Regards'
  
  Abhishek
  
  

  0
• sunshaoqing

  March 2014

  Thank you very much!
  I will try it.

  0
• Abhishek_Rana Vertica Employee Employee

  March 2014

  I missed the full syntax , it should be like this:
  
  select EXPORT_OBJECTS( '/tmp/design.sql', 'object_name');
  

  0
• sunshaoqing

  March 2014

  thanks!

  0