sreekanth

• Nov 21st, 2006

 

create table tablename2 (variables ) as select (variables) from tableprevious

satish

• Nov 22nd, 2006

 

Its simple to create a table structure (with out data) from other table by:

Create new_table as select * from old_table where 1=2;

bommana_vidyasagar

 Profile Answers by bommana_vidyasagar Questions by bommana_vidyasagar

• Nov 22nd, 2006

 

create table temp as select * from emp where 1=2 ;

Emp table frm scott schema

bye

TANVEER

• Nov 22nd, 2006

 

CREATE TABLE  <Any-table-name>

AS

SELECT *

FROM <table-name>

WHERE 1=2;

Mark

• Dec 2nd, 2006

 

In SQL Server:

Select top 0 *

into table_destination

from table_source

Pawan Ahuja

• Dec 3rd, 2006

 

create table tab_name as select * from old_tab_name

where 1=2;

Regards

Pawan Ahuja

faheem quadri

• Dec 16th, 2006

 

create table <new table name>as select * from<original tablename> where 1>2;

nareshgupta12

 Profile Answers by nareshgupta12 Questions by nareshgupta12

• Jan 8th, 2007

 

To create a table in oracle from using the existing table without taking records from the original table  .The command will be

Create table <table name > as select * from <oldtable name > where condition which should not ture in the old table

e.g

create table t1 as select * from t2 where age=0;

in above example age can not be 0 for any value.

So , in above case only the sturcture of the table will copy and no records will be there in the new table .

Rohan Deshpande

• Jan 30th, 2007

 

create table as select * from where 4=5; we must mention the condition in where clause.and that condition should not satisfy.so you can give any condition.

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 20th, 2007

 

Create table tab1 as select * from tab2 where 1=2;


In where clause give any condition which never satisfies,just like the above condition.
Never  will be 1 equal to 2.Hence it fails and only the structure of tab2 will be created as structure of tab1.

rakhee

• Nov 20th, 2007

 

Yes, Suppose you have a table emp and you want to create another table emp1 with same structure as wmp with no rows then create table emp1
as
select * from emp
where 0=1;

joybanerjee

 Profile Answers by joybanerjee Questions by joybanerjee

• Dec 15th, 2007

 

create table  t_1 as  select  * from  t_2  where  1=2

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 22nd, 2008

 

CREATE TABLE EMP_3

AS SELECT * FROM EMP

WHERE EMPNO IS NULL

You can use any primary key column in where clause.

Naval Kishor Pandey

 Profile Answers by Naval Kishor Pandey 

• May 25th, 2011

 

SELECT * INTO NewTable FROM OldTable WHERE 1 = 2

machomanic

 Profile Answers by machomanic 

• May 26th, 2011

 

Hello,

here is the query,

CREATE TABLE EMP1 AS SELECT * FROM EMP WHERE 1=2;

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

create table emp as select * from student where 1=2;

Mohammad salman

• Sep 29th, 2018

 

its not working,,,,
error is that
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword As.