fgl_find_table() will tell you if a specific table exists in the current database.
The function takes a CHAR(64) variable as its argument, which is the name of the table, and returns TRUE if the table exists within the current database.
DATABASE cms
MAIN
IF fgl_find_table("contact") THEN
DISPLAY "The table contact exists in CMS" at 5,5
ELSE
DISPLAY "The table contact DOES NOT exist in CMS" at 5,5
END IF
CALL fgl_winmessage("Exit","Press any key to close this demo application","info")
END MAIN