/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 vote275 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote256 views1 answer
Plsql find location of procedure
SQL
1 vote267 views1 answer
Second last highest id in sql
SQL
0 vote273 views1 answer
Sql missing values
SQL
0 vote251 views5 answers
Sql table intermédiaire
SQL
0 vote252 views1 answer
T sql check active deadlock
SQL
0 vote208 views1 answer
Hangfire clean script
SQL
1 vote259 views2 answers
Install mysqldump ubuntu
SQL
4 votes249 views2 answers
Mysql show indexes on table
SQL
0 vote260 views1 answer
How to close external sql connection in laravel
SQL

Share