SQL Views

SQL views allow users to retrieve data directly from the relation database system that powers ACE. Views combine one or more underlying database tables to provide a stable and unified interface from which SQL Reports can be created.

Locating 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 xls document corresponds to a view containing specific columns and data types.

For additional information, see Common Syntax: SQL.