Script Ordering

Schema Script is a linear procedural script. This means that validation happens as each script command is read from the script file. Thus, the order that commands appear in the script is important.

For example, an <addColumn> command cannot occur before the table has been added.

Command Dependencies:

Command

Is Dependent On

<addColumn>

The table must already exist in the database, or an <addTable> command must have already occurred in the script.

<addRelation>

The table must already exist in the database, or an <addTable> command must have already occurred in the script.

<addIndex>

The table must already exist in the database, or an <addTable> command must have already occurred in the script.

<addJoin>

The view must already exist in the database, or an <addView> command must have already occurred in the script.

The table must already exist in the database, or an <addTable> command must have already occurred in the script.

The relation must already exist in the database, or an <addRelation> command must have already occurred in the script.

<addViewColumn>

The join that this viewColumn comes from must already exist in the database, or an <addJoin> command must have already occurred in the script.


Refer to the Schema Script XML Reference for complete details on schema scripting.

See Also

Working with SchemaScript

SchemaScript Example

Schema Script Namespaces

Next

Schema Script Namespaces

Script Ordering