Re: sql syntax

Posted in 2000

Erik Stahlhut — Wed, 15 Nov 2000 09:39:17 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi Frankie, please try this: if (table in (Select tabname from systables)) then ... else ... Regards Erik Stahlhut ISR Information Products AG www.isr.de "Frankie" <kehunchi@cm1.hinet.net> schrieb im Newsbeitrag news:8usth1$2ia7$1@news.is.net.tw... > Hello everybody: > I want to check if a table exist in a database,what sql syntax can I > write? > Now my requirement is follow:(my DB is informix 7.3) > > If (table exist) then > drop table > create table > ... > > > Thank's everybody. > > -- > Frankie Ke > Colovos Machinery Corp > TEL:(04)4070810*203 FAX:(04)-4071129 > Email:kehunchi@cm1.hinet.net > > >