Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

create a new table from another table

Pawan kumar 2772 10 Mar 2011

sir i want to create new table from another table (only structure of table) and then record of table.

Pawan kumar

Other

2 Answers

Shankar M 09 Apr 2013

Hi Pawan,

You can try,

In SQL Server,

SELECT * INTO NEWTABLE FROM OLDTABLE WHERE 1 = 0
In Oracle (CTAS -Create Table as Select)
CREATE TABLE NEWTABLE AS SELECT * FROM OLDTABLE WHERE 1 = 0

Here 1 = 0 is the condition that is never satisfied, So the data is not inserted into the new table.

Thanks,

Shankar

Anonymous User 11 Mar 2011

Hi Pawan,
You can use this syntax,

CREATE TABLE new_table
  AS (SELECT * FROM old_table);

Visit this link for more syntax:

http://www.techonthenet.com/sql/tables/create_table2.php

advertising