Previous Topic: The Query ToolNext Topic: Open a Query


Create a Query

You can create a query (SELECT statement) by entering text directly in the Query box, or by pasting text from another source.

To create a query

  1. Click Query Tool on the Tools menu.

    The Query Tool opens.

  2. Enter your query in the Query box, or click the paste button on the toolbar to paste a query from another source.

    Your query is ready for execution. Use other features in the Query Tool to execute and save the query.

Note: Before you can execute a query you must be connected to erwin ODBC or to a database. For sample queries and the details of schemas and tables, see the Generating or Viewing Reports scenario. The scenario is available in the bookshelf under Product Documentation By Role, Data Architect section.

More information:

Execute a Query Against erwin ODBC

Execute a Query Against a Database

Save a Query