/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 vote120 views1 answer
How to get one year old query from plan cache
SQL
6 votes169 views2 answers
Database url postgres
SQL
11 votes110 views2 answers
Docker create postgres db
SQL
1 vote114 views1 answer
Create email address from first and last name in sql
SQL
3 votes132 views3 answers
Sql current year
SQL
0 vote266 views1 answer
Current month transactions in mysql
SQL
5 votes122 views1 answer
Oracle add time to date
SQL
0 vote108 views1 answer
Sort by last two number sql
SQL
14 votes115 views4 answers
Import database through command line
SQL
2 votes102 views1 answer
Add 2 hours to current time in MySQL
SQL

Share