Saving a statement for later use
The statements you create can be saved and recalled for use with other calculated representation or calculated field rules. The statements are saved as query files, which place the SELECT, FROM, and WHERE information on separate lines, as shown below:
, CITY_NAME , US_UrbanAreas POP1990 = US_UrbanAreas.POPULATION
- Start ArcMap.
- If necessary, load data in the map.
- Define the SQL statement.
The Save As dialog box appears.
- Navigate to the directory in which you want to save the SQL statement.
- Type a name in the File name text box.
The Query Builder dialog box appears.
You can clear the contents of the SELECT OBJECTID and WHERE fields by clicking Clear.