How to get a list of tables from a database

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

Hi @hhkim

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

2 Likes

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

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

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