/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

3 votes159 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
3 votes180 views2 answers
Synonym oracle
SQL
5 votes152 views2 answers
Sql create tabel with primary key auto_increment code
SQL
4 votes148 views2 answers
Sql table
SQL
16 votes150 views2 answers
Sql exists
SQL
1 vote144 views1 answer
Woocommerce mysql price table
SQL
1 vote164 views1 answer
Oracle sql pad left zeros
SQL
1 vote182 views2 answers
Mysql add column tinyint default 0
SQL
0 vote182 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote146 views1 answer
Make a socket server to detect changes in mysql
SQL

Share