This article provides an example to create table based on existing table.
Createtable guj_cust asselect * from cust wherestatelike ‘Gujarat’;