/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 vote147 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote126 views2 answers
Py sqlite if entry exists
SQL
0 vote124 views1 answer
Sql tabelle erstellen
SQL
1 vote112 views1 answer
Copy postgres table from one schema into another
SQL
4 votes134 views1 answer
Conda install sqlalchemy
SQL
2 votes132 views1 answer
How to show the whole table in sql
SQL
0 vote115 views2 answers
Android sqlite tutorial for beginners
SQL
3 votes124 views2 answers
Find string in stored procedure sql server
SQL
0 vote109 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
-1 vote123 views1 answer
Mac mysql workbench console
SQL

Share