/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 vote348 views1 answer
How to compile a function in oracle
SQL
0 vote301 views1 answer
Mysql sql select one day before
SQL
0 vote307 views1 answer
Sql join on a subquery
SQL
4 votes302 views2 answers
Postgresql default value
SQL
2 votes293 views1 answer
Check isolation level in mysql
SQL
0 vote302 views1 answer
Mysql grant access to one database
SQL
0 vote309 views1 answer
Find usage of table in sql server
SQL
1 vote315 views1 answer
Postgres check blocking
SQL
0 vote268 views1 answer
Create duplicate table in postgresql
SQL
0 vote368 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL

Share