/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 vote278 views1 answer
Jooq replace
SQL
0 vote255 views2 answers
Soql last year
SQL
0 vote261 views1 answer
Mysql config address
SQL
0 vote198 views1 answer
Sqlite referential integrity
SQL
0 vote212 views1 answer
Where in clause tsql
SQL
0 vote218 views1 answer
Distance calculator from lat long sql query
SQL
3 votes245 views1 answer
Unsigned int in mysql
SQL
0 vote231 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote194 views1 answer
How to output a different column name in mysql
SQL
3 votes284 views1 answer
Delete all content in table mysql
SQL

Share