Re: Create Table Statement

Posted in 1999

Obnoxio The Clown — Thu, 01 Jul 1999 14:07:59 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Matthias Kallage" <mkallage@bigdutchman.de> > >is it possible to copy a table (300.000 rows) into another table without >the >rows >for example: >CREATE TABLE tab1>AS SELECT * from tab2 >WHERE 1<0 > >The goal is to duplicate a tabel with all columns but without any row Sounds like you need DBSchema. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com