How to check whether a table exists or not?

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

Preview text:

Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Navigation

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

Using FIBPlus, I did everything I could only dream of with other data connectors and InterBase in 2 weeks. I am very happy with your work. Together we are successful. >>

Mark McFarlane

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.

Navigation