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... */
Navigation
"If every software supplier had a product, and a support staff as good as yours, life would be much easier for developers." >>John Hart
