The SQL console treats an SWD as a database, an Overlay as a table within that database and a schema column as a column within that table.
The console is based on SQLite and supports most normal SQLite SELECT syntax but not any of the Data definition language (DDL), eg CREATE TABLE, etc.
SIS Item geometry (automatically converted to OGC Simple Features-compatible types) is accessed using the built-in sis_geometry column.
Watch video SQL Control Bar in Cadcorp SIS Desktop online without registration, duration hours minute second in high quality. This video was added by user cadcorptv 09 September 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 204 once and liked it 2 people.