VistaDB 2.1 - Data Builder

Data Builder lets you select and open any VistaDB .VDB database for editing.

Data Builder provides a visual overview of all the contents including Tables, Columns, Indexes, Triggers, Constraints and data.

Data Builder allows you to run interactive V-SQL directly on your data and it displays the time required to execute your SQL commands.

The V-SQL interactive screen displays results.

Data Builder tracks the history of all SQL statements that you have processed, which allows you to quickly re-run or edit previous statements.

Creating and restructuring database tables is easy. The Table editor lets you define a rich set of column types, default values and captions. Identity fields are also fully supported as well as Null values. You may optionally set table encryption well.

The Index Editor allows you to create simple and compound indexes. VistaDB index definitions are highly flexible in that you can combine multiple columns in a single index and you can create powerful index expressions using the Expression Builder.

The V-Script Expression Builder is used with several data editors.

This editor allows you to visually create Triggers, Constraints and Indexes by selecting built-in VistaDB functions to use in conjunction with table columns. Over 35 pre-built functions are available.