Re: Testing for table existance

["Wanko, Christopher G, CFCTR" <apollo@ATT.COM>]

> I'm testing for the existance of a table at the start of my sqr.

Do yourself a favor and query the system tables, if you have access to them.
In Sybase, I'd say something like:

Begin-Select
name &isnamethere
from sysobjects
where type = 'U' and name = [$tablename]
End-Select

Check the value of &isnamethere.

-Chris