create table new_Table_name as (select * from old_table_name where 1=2);
It is copy only structure of old table.
Type: Posts; User: yuvarajan2000; Keyword(s):
create table new_Table_name as (select * from old_table_name where 1=2);
It is copy only structure of old table.
desc tablename