/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

5 votes384 views2 answers
Sql constraint check value in list
SQL
0 vote337 views1 answer
Oracle call a function in a insert statement
SQL
2 votes362 views2 answers
Created at and updated at in mysql
SQL
1 vote380 views1 answer
Sql server 2012 query history
SQL
2 votes342 views1 answer
Possgress drop if exists table
SQL
0 vote347 views1 answer
First Step in installing SQL workbench
SQL
0 vote353 views2 answers
Sql query for getting details by id
SQL
0 vote346 views1 answer
How to use query in nosql
SQL
0 vote343 views1 answer
C# check if mysql query modified rows
SQL
14 votes335 views2 answers
How to auto increment in sql
SQL

Share