Using SQL

InfoWorks ICM implements its own subset of SQL (Structured Query Language) for selecting and updating network objects using specified criteria.

An SQL query consists of a number of clauses separated by semi-colons. Each clause can do one of the following:

The SQL query is built on the SQL Dialog. To open the dialog, choose SQL select from the Selection menu, or click the button from the Selection toolbar.

SQL Syntax

Selecting Objects Using SQL

Updating Data Using SQL

SQL and Connected Objects

SQL and Array Data

SQL and Spatial Searches

SQL Examples

SQL Queries

SQL Dialog