hariprasadraja
10/10/2019 - 8:06 AM

sql create table like existing

CREATE TABLE [ IF NOT EXISTS ] new_table [ AS ] 
  SELECT expressions
  FROM existing_tables
  [WHERE conditions];