/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 votes89 views1 answer
Mysql get last day of month
SQL
9 votes86 views3 answers
Mysql get last id
SQL
2 votes84 views1 answer
Update trigger
SQL
2 votes77 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote88 views1 answer
Oracle archivelog usage
SQL
0 vote95 views1 answer
How to select all fieldsin a soql query
SQL
1 vote102 views1 answer
Decalre temp table sql
SQL
2 votes48 views1 answer
Foreign key example in dbms
SQL
2 votes94 views1 answer
Cast string to datetime mysql
SQL
7 votes92 views1 answer
Minecraft forge server host
SQL

Share