/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 vote227 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
6 votes238 views2 answers
Mysql get yesterday
SQL
0 vote242 views1 answer
Get a list of tables and the primary key
SQL
0 vote247 views1 answer
PSQL use LIKE with timestamps
SQL
2 votes262 views2 answers
Sql lag
SQL
6 votes290 views3 answers
Check if string contains substring sql
SQL
0 vote239 views1 answer
Enable sql server full text indexing
SQL
0 vote249 views1 answer
MySQL update with subquery
SQL
0 vote235 views1 answer
Sql change date format
SQL
0 vote225 views1 answer
Database get 10 user aleatory
SQL

Share