DESCRIBE ASSOCIATION

Synopsis

DESCRIBE ASSOCIATION <qualified_name>

Description

Shows the complete MDL source for an association, including the FROM entity, TO entity, association type (Reference or ReferenceSet), owner, and delete behavior. The output is round-trippable MDL that can be used directly in a CREATE ASSOCIATION statement.

Associations define relationships between entities. A Reference type is a one-to-many relationship, while ReferenceSet is many-to-many.

Parameters

qualified_name

A Module.AssociationName reference identifying the association to describe. Both the module and association name are required.

Examples

Describe an association:

DESCRIBE ASSOCIATION Sales.Order_Customer

Example output:

/** Links orders to customers */
CREATE ASSOCIATION Sales.Order_Customer
  FROM Sales.Customer
  TO Sales.Order
  TYPE Reference
  OWNER Default
  DELETE_BEHAVIOR DELETE_BUT_KEEP_REFERENCES;

Describe a many-to-many association:

DESCRIBE ASSOCIATION Sales.Order_Product

See Also

SHOW ASSOCIATIONS, DESCRIBE ENTITY, SHOW MODULES