About SQL in InfoWorks WS Pro

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

A 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.

SQL queries can be saved as stored queries within stored query groups.

Sets of predefined stored queries are available as an option when creating a stored query group.


SQL and stored queries