addJoin

The addJoin element allows a new join to be added to the schema.

Example:

<addJoin kind="Inner" view="my_new_view" relation="relationName" table="tableName">
   <description>description</description>
</addJoin>

Required Attributes:

Attribute Name

Description

kind

Specifies the kind of the join. Valid values are:

  • Inner
  • Outer

view

The name of the view on which this join should be added to.

table

The name of the table to be joined to.

relation

The name of the relation on the table used for the join.


Optional Child Elements:

Element Name

Default

Description

description

 

Description of the join.

alias

 

Name of the alias for the table defined in the table attribute.

toAlias

 

Name of the alias for the table referenced by the other side of the relation.

See Also

schemaScript

addColumn

addExclusiveRelationSet

addIndex

addRelation

addSqlView

addSqlViewColumn

addTable

addView

addViewColumn

updateColumn

updateIndex

updateJoin

updateRelation

updateTable

updateSchema

updateSqlView

updateSqlViewColumn

updateView

updateViewColumn

Next

addJoin Examples

addJoin