/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

7 votes367 views2 answers
Execute mysql file
SQL
1 vote342 views1 answer
Postgres regex remove special characters
SQL
2 votes371 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
12 votes370 views4 answers
How to take database dump in postgresql
SQL
4 votes361 views3 answers
Postgres set default value
SQL
0 vote325 views0 answer
SQL
-1 vote350 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote363 views1 answer
Join to find results not in another table
SQL
5 votes351 views1 answer
Pl sql asynchronous procedure calls
SQL
1 vote386 views1 answer
Customer using hdfc bank sql query
SQL

Share