/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 vote136 views1 answer
Sql dmv to capture updates
SQL
0 vote151 views1 answer
Find wordpress version in database
SQL
1 vote133 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote136 views1 answer
Sql include rows with 0 values
SQL
0 vote129 views1 answer
Sql get number of days between two dates
SQL
0 vote129 views1 answer
Cannot pip install mysqlclient
SQL
0 vote129 views1 answer
Sql: extract day text from datetime value
SQL
9 votes157 views3 answers
Date format in sql
SQL
0 vote177 views1 answer
Having all mysql
SQL
0 vote127 views1 answer
Fast sql column count
SQL

Share