/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

0 vote300 views1 answer
How to find unique key in sql
SQL
2 votes295 views1 answer
Sql find missing values between two tables
SQL
1 vote322 views1 answer
Sql group by sum with condition
SQL
11 votes318 views1 answer
Mysql order by two columns priority
SQL
7 votes330 views3 answers
SQL create a new table
SQL
0 vote326 views1 answer
Create bdd mysql
SQL
0 vote320 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote282 views1 answer
Mariadb list tables
SQL
2 votes368 views1 answer
Sql string starts with
SQL
0 vote309 views1 answer
Mysql order by where condition sub query
SQL

Share