[Date Prev][Date Next][Thread Prev][Thread Next]
[SQRUG Home Page]
Re: Temporary Table Creation
- Subject: Re: Temporary Table Creation
- From: "Lauri H. Macha" <l.h.macha@LARC.NASA.GOV>
- Date: Thu, 30 Nov 2000 15:33:26 -0500
Hi, Tara ...
Try the following:
create table TEMPTABLE as select * from ORIGTABLE;
(where TEMPTABLE is your new temporary table,
and ORIGTABLE is the existing table)
At 03:13 PM 11/30/00 -0500, you wrote:
I need to create a 'temporary table' that is a clone of an existing PS table. I would appreciate any input at all..
(Just a touch dusty on the SQR skills!)
Thanks in advance!
Tara Kurtz, HR-ease
Get more from the Web. FREE MSN Explorer download : <http://explorer.msn.com>http://explorer.msn.com