Subject Re: How to check if table exists?!
Author Svein Erling Tysvær
select 'Help, I exist!'
from rdb$relations
where rdb$relation_name = 'YourTable'

will tell you whether there exists a table or a view with the name
'YourTable'. Though I don't know how to separate views from tables if
you are spesifically looking for tables.


--- In, "matijamikac" wrote:
> How can I check if table exists in database using SQL?!
> Is it possible using some system tables?