topic Re: Check if Table available in Database in QlikView

Check if Table available in Database

phil-ebm — Mon, 26 Jan 2026 18:19:17 GMT

Hello

I spent a lot of Time in searching a solution for the topic but I can't find the right one.

My Problem is that I have a Load-Script for loading tables from several different Databases. Most of the tables are available in all of this Systems. They are decentral production servers. But some tables are not available in all Databases.

My question is:

Is there an option how i can check that the table exists in the database or not? And just when the table exist I start the Data-Load with a sql.

Regards

Philipp

Re: Check if Table available in Database

adamdavi3s — Thu, 09 Mar 2017 10:10:27 GMT

Hi Philipp,

Is this a SQL server?

If so then you can do your ODBC / OLEDB connect then run a:

select name

from sys.tables

where name = 'table to check'

Re: Check if Table available in Database

phil-ebm — Thu, 09 Mar 2017 10:11:40 GMT

Hi Adam

thanks for your reply.

Yes it's an Oracle SQL Server.

I will try it.

Re: Check if Table available in Database

PrashantSangle — Thu, 09 Mar 2017 10:12:36 GMT

Hi,

try with below sql query

SELECT TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'BASE TABLE'

Regards,

Prashant