/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

25 votes168 views4 answers
Sqlserver add column
SQL
0 vote238 views2 answers
Disadvantages of stored procedures sql
SQL
38 votes225 views4 answers
Count sql
SQL
2 votes170 views1 answer
Sql find not in list
SQL
8 votes195 views1 answer
Mac restore mysql database command line
SQL
1 vote164 views1 answer
Retrieve meaning
SQL
0 vote190 views1 answer
Sql anywhere create procedure
SQL
0 vote181 views1 answer
Get total and distict row diff in sql
SQL
0 vote169 views1 answer
Can you write relational algebra into sql queries
SQL
5 votes165 views2 answers
To date oracle
SQL

Share