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... */
In the 30 years in the IT industry from development to IT Manager, I haverarely used third party components but I would not be without your product. >>
John Hart ,Tradewinds Software Pty Ltd
