spanchi

 Profile Answers by spanchi 

• Jan 9th, 2007

 

If using a RDBMS such as oracle try using database objects.

lalit4untl

 Profile Answers by lalit4untl Questions by lalit4untl

• Jan 17th, 2007

 

hi ,

 try this this will copy only the structure of  table 2 into table 1, not the data.........

insert into table1 select * from table2 where 1=2;

bye....

geeth

• Feb 28th, 2007

 

hi,

try this


create table <table_name> as select * from xxx where 1=2

chandu

• Mar 14th, 2007

 

table1 select * from table2

mala321

 Profile Answers by mala321 

• Dec 24th, 2007

 

Hello,

Try this,

Create table <t1> as select * from <table2> where 3=4;

bye

rajiv.sriraj

 Profile Answers by rajiv.sriraj 

• May 9th, 2008

 

HI if u want to get the same table structure which is already existing in ur database then SQL QUERY IS create table <table name> as select * from <table name which is already in DB> where 1 = 2;
 
If u want data also then
 create table <table name> as select * from <table name which is already in DB> ;

venkatagsubbaiah

 Profile Answers by venkatagsubbaiah 

• Feb 4th, 2010

 

Create Table Tab1 as select  * from Tab2 where 1=2;