Re: sql syntax

Posted in 2000

Ed Brown — Wed, 15 Nov 2000 08:02:35 -0500 — source: Informix-list mailing list archive (1991-1998)

SELECT tabname FROM systables WHERE tabname="your_table" "Frankie" <kehunchi@cm1.hinet.net> wrote in message 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 > > >