/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

4 votes191 views2 answers
How to delete row in sql
SQL
-1 vote194 views3 answers
Update mongodb version ubuntu
SQL
0 vote305 views1 answer
Sql server query all database objects
SQL
0 vote202 views1 answer
How to list function in psql
SQL
25 votes235 views6 answers
Import database mysql command line
SQL
12 votes186 views2 answers
Delete all data in neo4j
SQL
3 votes206 views4 answers
Truncate syntax in sql
SQL
0 vote192 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote190 views1 answer
Mysql export and import
SQL
0 vote203 views1 answer
Every Derived yable must have its own alias
SQL

Share