Process Studio Workflow Database

[Snehal_Chavan]

How to fetch table names from the database?

[priyanka.gupta]

Hi Snehal,

We can use Execute SQL Script Plugin. Wherein we can write SQL query to retrieve list of Tables from database.
SQL Query To retrieve Table is
SELECT table_name FROM information_schema.tables WHERE table_schema =‘Database Name’;

example

SELECT table_name FROM information_schema.tables WHERE table_schema =‘test’;