• InfoWorks WS Pro

Introducing Structured Query Language in InfoWorks WS Pro

Describe SQLs and how they are applied in WS Pro.


Structured Query Language (SQL) is a database computer language designed for managing data in relational database management systems.

A presentation slide defining SQL and its scope, which includes data insert, query, update, delete, schema creation, and data access control.

The SQL language is sub-divided into several language elements.

A presentation slide describing SQL language elements, including clauses, expressions, predicates, queries, and statements.

InfoWorks WS Pro implements its own subset of SQL for selecting and updating network objects using specific criteria.

A presentation slide describing SQL implementation in InfoWorks WS Pro as flexible and powerful for performing a wide range of data analysis, with an image of a GeoPlan displaying SQL results.

The WS Pro SQL dialog allows you to create SQL queries manually or using the SQL builder.

A presentation slide describing the use of the WS Pro SQL dialog to create SQL queries manually or using the SQL builder, including an image of the dialog with a completed query.