[RBASE-L] - Re: Check for Existence of a Table

[Bill Downall]

Steve,

Here's one way:

SET VAR vTableExists INT

SELECT COUNT (*) INTO vTableExists FROM sys_tables +
WHERE sys_table_name = 'tablename'

IF vTableExists = 0 THEN
  CREATE TABLE ...
ENDIF

Bill

On 31 Aug 2004 at 10:39, J. Stephen Wills wrote:

> 
> What would anyone recommend as the best/easiest/fastest way to
> ascertain whether or not a table exists?
> 
> I need to check that a table exists at run-time. If it doesn't, then I
> CREATE TABLE ... 
> 
> CREATE TABLE ... TEMP is not a viable alternative in this particular
> context.
> 
> 
> TIA,
> Steve in Memphis