Object dependencies

You can specify whether an SQL command depends upon a DataBlade® module object or upon your SQL. These dependencies determine the sequence of SQL commands in the generated objects.sql script.

BladeSmith generates SQL in the following sequence:
  1. SQL commands to create objects upon which custom SQL commands depend
  2. Custom SQL commands
  3. SQL commands to create objects that depend upon custom SQL commands

The generated SQL scripts register dependencies when the DataBlade module is registered in a database.