/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 vote284 views1 answer
Conda install pymysql "windows"
SQL
0 vote283 views1 answer
Oracle sql generate list of days
SQL
0 vote275 views1 answer
Concatenate columns in table
SQL
0 vote281 views1 answer
Get first monday of month sql
SQL
0 vote306 views1 answer
Lost connection to mysql
SQL
50 votes416 views6 answers
Sql count duplicate rows
SQL
2 votes260 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote294 views1 answer
How to tell if i have lactose intolerance
SQL
1 vote319 views1 answer
Mysql take number in string
SQL
2 votes307 views4 answers
Check timezone of mysql database
SQL

Share