Doug, I be interested in a more elegant way of checking for the existence of a table too!
I use the count method: SET VAR vCount = 0 SELECT COUNT(*) INTO vCount FROM Sys_Tables + WHERE Sys_Table_Name = 'TableName' AND LIMIT = 1 Regards Lena From: [email protected] <[email protected]> On Behalf Of Doug Hamilton Sent: Tuesday, May 01, 2018 10:33 AM To: R:Base List <[email protected]> Subject: [RBASE-L] - Does Table exist? I'm drawing a blank - is there a command/function (in 9.5) to check for the existence of a table? I want to see if a temp table exists before I try to recreate it. I could try to count rows and check for error messages if the table isn't there but I suspect there's a more elegant method. 'Course, recreating an existing table would also give an error message... TIA, Doug Now to get more coffee.... [Image removed by sender.]<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> Virus-free. www.avast.com<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
