/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

13 votes189 views6 answers
Current date sql
SQL
2 votes229 views1 answer
Select from array in psql
SQL
0 vote184 views2 answers
Sqlite unique
SQL
0 vote196 views1 answer
Comparing with today and yesterday record in sql query
SQL
1 vote207 views1 answer
Load mysql dumb
SQL
0 vote201 views1 answer
Prodection ready postgres database step by step
SQL
0 vote189 views1 answer
Select password from user mysql
SQL
0 vote187 views1 answer
Update top 100 sql
SQL
0 vote151 views1 answer
Alter session set nls_language french
SQL
1 vote202 views2 answers
Mysql switch case
SQL

Share