# Process Studio Workflow Database

**URL:** <https://community.automationedge.com/t/process-studio-workflow-database/1849>\
**Category:** Get Help & Discuss\
**Created:** [March 26, 2020, 12:22pm UTC](https://community.automationedge.com/t/process-studio-workflow-database/1849 "2020-03-26T12:22:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Snehal\_Chavan](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@Snehal\_Chavan](https://community.automationedge.com/u/Snehal_Chavan)\
**Post date:** [March 26, 2020, 12:22pm UTC](https://community.automationedge.com/t/process-studio-workflow-database/1849/1 "2020-03-26T12:22:35Z")

</div>

How to fetch table names from the database?

---

<div class="post-metadata">

**Author:** ![priyanka.gupta](https://avatars.discourse-cdn.com/v4/letter/p/3be4f8/32.png) [@priyanka.gupta](https://community.automationedge.com/u/priyanka.gupta)\
**Post date:** [March 26, 2020, 12:23pm UTC](https://community.automationedge.com/t/process-studio-workflow-database/1849/2 "2020-03-26T12:23:02Z")

</div>

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’;