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*/
I've looked at FIBPlus and feel that it is one of the fastest (if not the fastest) IB components out there. Congratulations on doing such a fine job. >>Barry McClure
