Database Schema File (*.vdb)

What is a VDB file?

It stands for visual database file - it’s a simple way to describe the tables within a database which then makes it easier to work with databases within IguanaX.

Iguana includes a GUI editor which allows you to easily create or edit VDB files, defining tables and their key fields. You can also look at VDB files without an editor in a very simple to read JSON format.

Screen Shot 2024-02-08 at 1.05.39 PM.png

Note: It is recommended that column names do not contain spaces (ex. First Name). If column names have spaces, db.merge will not be able to be used and instead will have to write and execute SQL statements from the Translator.

If you want to use merge with spaces in column names you can use the custom merge module Customize custom_merge.lua for table and field names with spaces - iNTERFACEWARE Help Center

 

Related pages