/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 vote174 views2 answers
Android sqlite query join
SQL
1 vote168 views1 answer
Check message id sql server
SQL
0 vote180 views1 answer
Docker open terminal mysql server
SQL
0 vote192 views2 answers
Disadvantages of stored procedures sql
SQL
-1 vote147 views1 answer
Oracle db list usernames
SQL
0 vote176 views1 answer
Renommer table sql
SQL
5 votes197 views3 answers
Mysql remove unique constraint
SQL
7 votes197 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote189 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote192 views1 answer
Print mysql
SQL

Share