VistaDB 6
VistaDB / Tools User's Guide / Data Builder / Context Sensitive Screens / SQL Query Pane / Syntax Editor Advanced Options
Syntax Editor Advanced Options

There are a number of advanced features available through the Syntax Editor.

Collapsible Regions

SQL code may be surround by blocks to make them collapse in the editor.

Create Index Example
Copy Code
--region IndexCreation
CREATE INDEX [AttachmentByEventIDIndex] ON [TicketAttachments] ([TicketEventID]);
--end region 

The code block above looks like this in the editor opened and collapsed.

Pressing the - next to the block will collapse it very similar to how Visual Studio controls text blocks.

See Also