/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 vote357 views1 answer
Get create sql of hibernqte entity
SQL
1 vote331 views1 answer
Add sequence postgres
SQL
0 vote372 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote330 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote344 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote335 views1 answer
Mariadb maximum left join
SQL
0 vote332 views1 answer
Mysql show foreign keys column
SQL
0 vote345 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote436 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote370 views2 answers
Sql having multiple conditions
SQL

Share