---
title: "SQL Layouts"
slug: "sql-views"
updated: 2026-03-04T16:33:57Z
published: 2026-03-04T16:33:57Z
canonical: "docs.interprose.com/sql-views"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.interprose.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Views

SQL Views allow users to retrieve data directly from the relational database that powers ACE. A view combines data from one or more underlying database tables and presents it as a single, queryable structure.

Views provide a stable interface for reporting and are commonly used when creating SQL Reports in ACE.

### How to Locate SQL Views:

To locate ACE SQL views, follow these steps:

1. Go to **Help → Layout → SQL Views**
2. Download the file

Each sheet in the downloaded file represents a SQL view and lists the available columns and data types for that view.

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/Screenshot 2024-08-06 123331.png?sv=2026-02-06&spr=https&st=2026-10-31T17%3A46%3A11Z&se=2026-10-31T18%3A46%3A11Z&sr=c&sp=r&sig=aF0gl%2BGb%2Ft0E6o1LyvA84F7hgGIB4IroBtLaBML3F48%3D)

Image Displays Menu Navigation

For more information about writing SQL queries in ACE, see [Common Syntax: SQL](/v1/docs/common-syntax-sql).