/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

11 votes279 views1 answer
Get ddl materialized view oracle
SQL
4 votes269 views3 answers
Sqlite show columns
SQL
0 vote297 views1 answer
Mysql where don't have string
SQL
0 vote269 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
8 votes301 views6 answers
Sql insert
SQL
0 vote268 views1 answer
Sql server manager close connection
SQL
1 vote266 views1 answer
How to drop function in sql
SQL
0 vote267 views1 answer
Sql server remove 0 from left
SQL
0 vote264 views1 answer
Mysql remove tabs from string
SQL
5 votes323 views2 answers
How to ascending order in sql
SQL

Share