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

    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