Re: Table Creation
sathish sadagopan (s_sati@hotmail.com) wrote:
: Hi,
: I would like to know the informix equivalent of oracle's
: Create table A as (Select * from B ) ;
: TIA,
: Sathish
For ordinary tables, there is no equivalent. You must explicitly build
and then populate the new table.
You can:
select * from TABLEB into temp TABLEB;
but TABLEB goes away when your session is over.
: ______________________________________________________
: Get Your Private, Free Email at http://www.hotmail.com
--
---------------------------------------------------------------------------
Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide"
Slaving away on "INFORMIX DEBUGGERS Survival Guide", available early 1998
from Prentice Hall/Informix Press. If you have debugging tips, tools, or
ideas to share, please send me some e-mail.
---------------------------------------------------------------------------