/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 vote172 views1 answer
Utiliser sql ligne de commande
SQL
6 votes264 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
-1 vote177 views1 answer
Select first rows postgresql
SQL
7 votes168 views6 answers
Nth highest salary in sql
SQL
0 vote176 views1 answer
Get clob size oracle
SQL
1 vote164 views1 answer
Pv mysql import
SQL
0 vote183 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
7 votes179 views4 answers
Index in mysql
SQL
2 votes123 views1 answer
Mysql admin u root p password change password
SQL
0 vote176 views1 answer
Recursive query herarchical data sql server
SQL

Share