/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 vote205 views1 answer
Mysql select month and year
SQL
0 vote214 views1 answer
Replace content value from old to new sql
SQL
0 vote226 views3 answers
Sql server import json
SQL
2 votes270 views1 answer
Create delete procedure mysql
SQL
0 vote255 views1 answer
Mysql streaming example
SQL
4 votes220 views2 answers
Mysql show indexes on table
SQL
1 vote185 views1 answer
Python escape string for sql
SQL
0 vote215 views1 answer
How to check the port of mysql installation in mac
SQL
10 votes238 views2 answers
Select nextval from sequence oracle
SQL
1 vote213 views2 answers
Datetrunc hour snowflake
SQL

Share