/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 vote135 views1 answer
Get number of table colums in sql query
SQL
0 vote140 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
2 votes170 views1 answer
Merge two columns in sql oracle
SQL
2 votes146 views1 answer
Mysql trigger after update
SQL
22 votes203 views4 answers
Mysql date format
SQL
0 vote148 views1 answer
How to access to mysql without root
SQL
0 vote144 views1 answer
Mysql database hyphen
SQL
0 vote132 views1 answer
Postgresql update to unique
SQL
0 vote134 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote149 views2 answers
Starts and end with vowel sql
SQL

Share