Re: how to test if database then table exists

Posted in 1998

HARINATH VENKATA — Fri, 17 Jul 1998 00:48:54 -0400 — source: Informix-list mailing list archive (1991-1998)

Try to check in the sysmaster database for the database /table your are searching for. stevesaroff@my-dejanews.com wrote in message <6om077$vav$1@nnrp1.dejanews.com>... >For a simple unix shell script (or a compiled esql/c programm called by a >shell script) running on the machine where the sql server is located, what >would be the simplist and cleanest way to find out 1) does the database >exist? 2) does a specific table exist? > >The script will then create the database if it doesnt exist, and will create >the table if it doesn't exist. > >Thanks in advance, > >steve saroff >ssaroff@freemail.com > > >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum