/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 vote182 views1 answer
Delete double on SQL with multiple primary keys
SQL
1 vote181 views1 answer
Where date = max(date) in sql
SQL
0 vote183 views1 answer
Get number of tables in database sql
SQL
-1 vote183 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote150 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote179 views1 answer
Report in database
SQL
0 vote150 views1 answer
Mariadb list tables
SQL
2 votes196 views2 answers
Change mysql password from command line
SQL
1 vote197 views1 answer
Alter constraint in sql
SQL
0 vote179 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL

Share