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:
Go to Help → Layout → SQL Views
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.