[RBASE-L] - Re: CHKTABLE?

[Albert Berry]

Matthew - I'm late to the table, but here is the script for a stored 
procedure I put in databases. I use it to check and drop tables and/or 
views without showing error messages such as one gets when dropping a 
table that is not there. The line that's needed in command files is 
simple. If this is any use to you, it's yours. Look up the PUT command 
to put the stored procedure into the database, or just use it as a .rmd 
and RUN DropTable.rmd. Notice the similarity between the second command 
line to the replies you already have.

CALL DropTable ("table name here")
-- DropTable.prc
SET VAR vTabName TEXT
SELECT COUNT(*) INTO vCount FROM sys_tables WHERE sys_table_name = .vTabName
IF vCount > 0 THEN
   DROP TABLE &vTabName
ENDIF
RETURN