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
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.
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
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.