Don,
try something like
SELECT COUNT(*)
FROM RDB$RELATIONS
WHERE RDB$RELATION_NAME=:YourTableName

HTH,
Set

Don Schoeman wrote:

> I would like to automatically create a table if it doesn't exist. However, I
> would like to check if the table doesn't already exist within the SQL query.
> Can it be done?
>
> Best regards,
> Don Schoeman
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/