---
title: "Show generated SQL"
id: "show-generated-sql"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/show-generated-sql"
updated: 2026-10-19T00:54:09Z
---

# Show generated SQL

You can view the SQL ![](/resources/Storage/ehr-user-guide/icons/info%20icon%20-%20small.png) code generated by a query. ![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png)
SQL = Structured Query Language is a programming language used to talk to databases. With SQL, you can store, manipulate, and retrieve data from relational databases.
To view SQL code:

1. At the **Query Manager**screen, after you've defined and run a query, click **View**, and then select one of the following options:
    1. **Show SQL**. **** EmpowerHR displays the generated SQL in a raw form, without prompting for, and performing parameter substitution.
    2. **Show SQL with Parameters**. EmpowerHR prompts you to enter****parameters, and then displays the SQL with substituted parameters.
2. To save the SQL script, at the SQL window, click **File**, and then select **Write to File**.
3. **Save** the file.

| Next topic<br><br>[Advanced query manager](/articles/ehr-user-guide/advanced-query-manager) |
| --- |

© 2023 Fusion5. All rights reserved.