How to check whether a table exists or not?

Home :: FIBPlus :: Articles :: Frequently Asked Questions (FAQ)

Counter:	2035
Published:	2007-01-29 19:11:33

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*/

Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Download
Purchase
Support
Screenshots
Articles
Features
Testimonials
Sales Geography
Who uses FIBPlus?

BrotherSoft Review Staff give one product the maximum 5 out of 5 Rating because this product is easy to use, it has a professional-looking interface, it is excellent compared to other programs in this section and so on >>

Echo Wang, Developer support leader

FOR CUSTOMERS
Download full versions and updates in our Customer's Center

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.