Check if Table available in Database

[phil-ebm]

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

[adamdavi3s]

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'

[phil-ebm]

Hi Adam

thanks for your reply.

Yes it's an Oracle SQL Server.

I will try it.

[PrashantSangle]

Hi,

try with below sql query

SELECT TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'BASE TABLE'

Regards,

Prashant