/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

28 votes204 views6 answers
Foreign key
SQL
15 votes151 views2 answers
How to know the username of postgresql
SQL
1 vote131 views1 answer
Mysql select another database
SQL
0 vote132 views1 answer
Mysql sql select one day before
SQL
0 vote181 views2 answers
How to install psql in ubuntu
SQL
4 votes178 views1 answer
Postgresql change default value
SQL
8 votes139 views2 answers
Replace string value in sql
SQL
0 vote141 views1 answer
Drop tables from local database postgres pgadmin
SQL
51 votes244 views6 answers
Change column name sql
SQL
31 votes153 views4 answers
How to get duplicate records with multiple field in sql
SQL

Share