SHOW CREATE TABLE

Syntax

SHOW CREATE TABLE table_name

Description

This statement is used to display the SQL creating statement for a specified data table.

Example

To display the SQL statements that can be used to create the table orders:

 show create table orders;
              Create Table              
----------------------------------------
 CREATE TABLE hive.default.orders (     
    orderkey bigint,                    
    orderstatus varchar,                
    totalprice double,                  
    orderdate date                      
 )                                      
 COMMENT 'tt1_tab'                      
 WITH (                                 
    external = true,                    
    format = 'ORC',                     
    location = 'hdfs://hacluster/user', 
    orc_compress = 'GZIP',              
    orc_compress_size = 262144,         
    orc_row_index_stride = 10000,       
    orc_stripe_size = 67108864          
 )                                      
(1 row)