/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 vote108 views2 answers
How to start postgresql laravel
SQL
0 vote120 views1 answer
Mariadb errno 121
SQL
0 vote125 views1 answer
SQL FROM-Klausel
SQL
0 vote133 views2 answers
Jsonb
SQL
0 vote121 views1 answer
SQL Server modify_timestamp trigger
SQL
2 votes132 views1 answer
Mysql id of inserted row
SQL
4 votes185 views1 answer
Mysql store ip address
SQL
0 vote203 views1 answer
Sql insert exemplo
SQL
0 vote91 views1 answer
Query for maximum salary
SQL
0 vote127 views1 answer
How to close external sql connection in laravel
SQL

Share