OraFAQ Forum: SQL & PL/SQL » how to create table with structure only based on another table with data

Home » SQL & PL/SQL » SQL & PL/SQL » how to create table with structure only based on another table with data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to create table with structure only based on another table with data [message #18354]

Tue, 29 January 2002 06:13

ksr
Messages: 112
Registered: January 2002

Senior Member

Hi,
how to create table with structure only based on another table with data.
I have table1 with 100 records,
now i want to create table2 with the same structure as table1 but without the data.

Report message to a moderator

Re: how to create table with structure only based on another table with data [message #18355 is a reply to message #18354]

Tue, 29 January 2002 06:37

sokeh
Messages: 77
Registered: August 2000

Member

try:
create first_table as
select * from original_table
where 1=2;
that way, 1 is not going to be 2 and all data structure is moved over to the new table without data.

Report message to a moderator

Previous Topic:	Query error frustrating beginner
Next Topic:	Select in update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 19 08:30:15 CDT 2025