Author Topic: Teradata SHOW Command  (Read 1664 times)

Offline Mahadev

  • Administrator
  • Hero Member
  • *****
  • Posts: 717
  • Karma: +1/-0
    • View Profile
    • QueryJunction
Teradata SHOW Command
« on: January 13, 2012, 05:12:19 AM »
01) The SHOW command displays the current Data Definition Language (DDL) of a database object
02) The SHOW command is used get the object creation script.
03) Table Details
   SHOW TABLE <table_name>;

04) View Details.
   SHOW VIEW <view_name>;

05) Macro Details
   SHOW MACRO <macro_name>;