How to get a list of tables from a database

KNIME Analytics Platform
1

Hello.

I was wondering how to get a list of tables from a database.

Please let me know if there is a good method.

Thanks,
hhkim

2

Hi @hhkim

This is impossible to answer without knowing which db type you are looking to get this from.

2 Likes
3

Hello @hhkim
As a general answer for SQL related DB: You can get all the system tables with a Custom Query in DB Table Selector node. You can pull out the query with a DB Reader node.

SQL Statement:

SELECT *
FROM sys.Tables

BR

3 Likes
4

Thank you for your reply.

I think if I don’t have a permission that can select sys table, I can’t use this way.

So I just want to use “show tables” query and see the result as table.

Thanks,
hhkim

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.