/SQL/Create empty table from existing table

Create empty table from existing table

Create empty table from existing table

//this will create new Empty table

CREATE TABLE TableName AS (SELECT * FROM ExistingTable WHERE 1=2);

1

Write a query to create an empty table from an existing table?

CREATE TABLE new_table
  AS (SELECT *
      FROM old_table WHERE 1=2);

1

Source: techonthenet.com

Similar codes

1 vote349 views1 answer
Find size of all DB's postgres
SQL
0 vote385 views1 answer
How to check common records in 2 table
SQL
0 vote296 views2 answers
Mysql add days to date
SQL
0 vote317 views1 answer
How to login to mysql in homestead
SQL
8 votes339 views2 answers
Between operator
SQL
0 vote287 views1 answer
Mysql error codeigniter
SQL
59 votes518 views6 answers
Alter table sql
SQL
0 vote303 views2 answers
Sql max count
SQL
0 vote356 views1 answer
Drop view sql
SQL
0 vote311 views1 answer
Flask sqlalchemy remove duplicates
SQL

Share