I'm not responding to your entire email, only the question far below. On my employer's system, we use a query named "$CMD_ISDATABASECONSTRUCTED" to check for whether the database is created. The query is simple:
"Analyze Categories;" If the Categories table does not yet exist, the query fails. If the Categories table already exists, the query succeeds. This solution suffices for our needs. Lee Crain ______________________________ ".....my question is if there's a better solution for check if the database is already created, something like a "describe" SQL Command (in oracle) that help to know if the schema is already there on the database?" Thank you! -------------------------------------------------------------------------- --- To unsubscribe, send email to [EMAIL PROTECTED] -------------------------------------------------------------------------- --- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
