[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Temporary Table Creation



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)

Lauri Macha


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