/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

1 vote140 views1 answer
Create sample data postgresql
SQL
0 vote214 views1 answer
Example database query
SQL
0 vote164 views1 answer
How to create a table in sql stack overflow
SQL
0 vote149 views1 answer
Mysql get longest string in column
SQL
2 votes140 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
5 votes143 views1 answer
JBDC
SQL
1 vote156 views1 answer
Psql import backup file for windows
SQL
1 vote159 views1 answer
Find difference in dates sql
SQL
3 votes145 views3 answers
Sql last week
SQL
1 vote163 views1 answer
Create index concurrently postgres
SQL

Share