/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

5 votes146 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote139 views1 answer
How to add more columns to a table in mysql
SQL
2 votes156 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote137 views10 answers
Sql statement checker corrector
SQL
28 votes140 views6 answers
Mysql change user password
SQL
0 vote147 views1 answer
Comma seperated join mssql
SQL
10 votes144 views6 answers
Between sql
SQL
1 vote145 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
4 votes150 views3 answers
Check if two date ranges overlap sql server
SQL
1 vote129 views1 answer
Can we drop a primary key
SQL

Share