/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 vote223 views1 answer
How to create notes in mysql
SQL
1 vote286 views1 answer
Alter constraint postgres
SQL
1 vote182 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote183 views1 answer
How to install mysql without admin rights
SQL
6 votes223 views2 answers
Subtr Oracle ?
SQL
5 votes176 views1 answer
Postgresql functions
SQL
5 votes171 views1 answer
Postgres integer to serial
SQL
1 vote184 views1 answer
Altering the column name in MySQL to have a default value
SQL
3 votes175 views2 answers
Oracle sql drop sequence
SQL
0 vote170 views1 answer
Calculate date and convert to yearsmysql
SQL

Share