/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

27 votes183 views3 answers
Mysql show tables in database
SQL
3 votes189 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
7 votes175 views6 answers
Reset identity column in sql server
SQL
-1 vote177 views1 answer
Io
SQL
3 votes175 views4 answers
Order by desc postgres
SQL
0 vote198 views1 answer
How to join result table in mysql
SQL
0 vote176 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote176 views1 answer
Mysql root permission denied lost
SQL
0 vote214 views1 answer
Stop and start mysql
SQL
0 vote212 views1 answer
Sql query to select even numbers
SQL

Share