> What would anyone recommend as the > best/easiest/fastest way to ascertain whether or not > a table exists?
SET VAR vCount INT = 0 SELECT COUNT(*) INTO vCount FROM SYS_TABLES + WHERE SYS_TABLE_NAME = 'YourTableName' IF vCount = 0 THEN CREATE TABLE . . . ENDIF I recall once seeing the mention of some undocumented functions that tell you whether a particular table or column exists, but I don't know what they are. -- Larry
