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 /* all tables will be shown */
WHERE RDB$RELATION_NAME = 'your_TABLE' /* particular table is checked*/
"If every software supplier had a product, and a support staff as good as yours, life would be much easier for developers." >>John Hart
