How to check whether a table exists or not?
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
|
Question: How to check whether a table exists or not?
Answer: SELECT RDB$RELATION_NAME FROM RDB$RELATIONS /* this will show all
tables */
WHERE RDB$RELATION_NAME = 'your_TABLE' /* with this will check for
some particular one... */
We use FIBPlus in all our applications, and we're very satisfied. If you're coming from IBX, FIBPlus is an especially good choice in as much as it has a common origin, and therefore, a similar structure, so conversion from IBX to FIBPlus is rather easy. >>Jonathan Neve, Microtech, France
