/
Database Schema File (*.vdb)

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 content

Understanding Databases in Iguana
Understanding Databases in Iguana
More like this
Creating a VDB
Creating a VDB
More like this
Components, Libraries and Collections
Components, Libraries and Collections
Read with this
Library to convert DBS files into VDB files
Library to convert DBS files into VDB files
More like this
Development
Read with this
Merging Records
Merging Records
More like this