Is this the sanctioned way to ascertain a table's existence?
Date: Fri, 16 Oct 2009 16:32:55 -0700 (PDT)
All my database accesses are done through Pro*C/C++.
Sometimes my code needs to verify whether a table exists. Years ago, I was about to post that particular questions here. I then realized that the following statements achieve the desired results:
EXEC SQL SELECT COUNT(1) INTO :howMany FROM user_tables WHERE table_name = :table_name;
if (howMany == 1)
Is that "the" proper way?
-Ramon Received on Fri Oct 16 2009 - 18:32:55 CDT