/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

1 vote242 views1 answer
Varchar plsql
SQL
1 vote283 views1 answer
Mariadb get column names from table
SQL
8 votes281 views6 answers
Sql insert
SQL
0 vote241 views1 answer
Get duplicate entry sql
SQL
16 votes257 views4 answers
Mysql import from sql file
SQL
0 vote239 views1 answer
How to see the query of a view in mysql
SQL
-1 vote255 views3 answers
Create temp table in sql
SQL
0 vote246 views1 answer
Replace \n sql
SQL
0 vote261 views1 answer
Where date in datetime mysql
SQL
5 votes267 views3 answers
Bash: mysql: command not found
SQL

Share