Rahul Tripathi

• Sep 21st, 2005

 

There is one method for copying the structure of table without copying the data is

create table NEWTable AS select * from OLDTABLE where 1=2

 rahultripathi@myway.com

rahultripathi

 Profile Answers by rahultripathi 

• Sep 21st, 2005

 

create table newtable AS select * from oldtable where 1=2

rahultripathi@myway.com

Shobha

 Profile Answers by Shobha 

• Sep 21st, 2005

 

but Rahul it's not run at SQL Query Analyzer, plze send the query for SQL,

Thanks

rahultripathi

 Profile Answers by rahultripathi 

• Sep 23rd, 2005

 

Shobha Wrote:

but Rahul it's not run at SQL Query Analyzer, plze send the query for SQL,

Thanks

Dear Shobha

If your using SQL SERVER please Use this Syntex :-

select * Into NEWTABLE from OLDTABLE where 1=2

PLZ REPLY / query rahultripathi@myway.com

Ajay Sharma

• Oct 13th, 2005

 

I think this should be more appropriate: Create table as select * from where 1=2;Here only the structure of the old table is copied and all the constraints imposed on the old table are not copied in the new table.This you can check by writing on SQL PROMPTSQL > desc SQL> desc Thanks!

Sridhar

• Jul 16th, 2006

 

This interview questions are belongs to SQL Server and people are giving answers to Oracle. Please be sure to understand the question and give the answer. Wrong answer may spoil a person interview. Here is the right answer
Without Data : select * into temp2 from temp where 1=2
With Data : select * into temp2 from temp
Regards
Sridhar

Deependra Singh Bhandari

• Mar 30th, 2007

 

create table NEWTable AS select * from OLDTABLE where 1=2can u used this command in Sql-Server -2005, i have used id but it is not workingwe can used this method as followingselect column name,columnname into newtablename from oldtablename where 1=2

Omprakash

• May 2nd, 2007

 

Hi All


SELECT TOP 0 * INTO Test1 FROM Test


The above query creates only structure. This works in SQL Server 2000 and 2005 also.

DJ

• Jun 5th, 2007

 

SELECT * INTO newtable FROM oldtable WHERE 1=2

chihoo2003

 Profile Answers by chihoo2003 

• Jan 9th, 2008

 

select * into NEW_TABLE from SOURCE_TABLE where 1=2

inetmk

 Profile Answers by inetmk 

• Feb 12th, 2008

 

select top 0 * into NEWTABLE from BASETABLE

kalyan212

 Profile Answers by kalyan212 

• Mar 6th, 2008

 

in the state ment
what the statement (where 1=2) specify
pls tell me

sharath206

 Profile Answers by sharath206 Questions by sharath206

• Mar 6th, 2008

 

using select into destination table from source table

bugeye

 Profile Answers by bugeye 

• Mar 14th, 2008

 

Right click table in SSMS > Script Table as > Create
Your question of "copy" infers that you want all the constraints.  The example that you give doesn't fill the requierments.  As you want the structure you would als want the constraints.

udayaveeramani

 Profile Answers by udayaveeramani 

• Jul 3rd, 2009

 

select column_list into new_table_name from old_table_name where false_condition(ex. 1!=1)

psingla

 Profile Answers by psingla Questions by psingla

• Mar 8th, 2010

 

sql server:
 select * into <new_table>
from <existing_table>
where 1=2

oracle:
create table <new_table> as
select * from <existing_table>
where 1=2

Piyush

• Nov 24th, 2014

 

Anyone please explain me why  " Where  1=2; "

sangita gupta

• Nov 26th, 2014

 

In the where statement we can write false condition which never true..

David Sarkar

 Profile Answers by David Sarkar 

• Dec 12th, 2014

 

Select * Into New_table FROM Old_Table WHERE 1=0;

asifeqbal

 Profile Answers by asifeqbal 

• Mar 18th, 2015

 

Select * Into From Where 1=2