I think doing a COUNT(*) FROM SYS_TABLES is the best way to check for an
existing table. With that being said and you truly want to delete/drop a
TEMPORARY table then recreate it I would just turn the error message off and
drop the table then turn the error message back on.
SET ERROR MESSAGE 2038 OFF
DROP myTempTblName
SET ERR0R MESSAGE 2038 ON
CREATE TEMPORARY myTempTblName ………
Buddy
From: [email protected] <[email protected]> On Behalf Of Lena
Dammstrom
Sent: Tuesday, May 1, 2018 11:41 AM
To: [email protected]
Subject: RE: [RBASE-L] - Does Table exist?
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] <mailto:[email protected]>
<[email protected] <mailto:[email protected]> > On Behalf Of Doug
Hamilton
Sent: Tuesday, May 01, 2018 10:33 AM
To: R:Base List <[email protected] <mailto:[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....
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon>
Virus-free.
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
www.avast.com
--
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]
<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.
