Relation Object (Model Designer)

Defines the relation to which a Role or Inheritance is bound. This object inherits properties from the Binding object.

Properties

Name Cardinality Type Description

Name

1

String

The name of the relation in the physical data source to which the Role or Inheritance is bound. The string cannot be empty. For Bindings on Inheritance, the target columns of each RelationEnd must comprise a unique key for the table associated with that end.

RelationEnd

0-1

Enum

Indicates which end of the relation the Role is bound to. There are two options: Source and Target. This attribute is required for Bindings on Role objects. This object is ignored for Bindings on Inheritance objects. For Bindings on Role objects with a cardinality of One or OptionalOne, the target columns of the RelationEnd must comprise a unique key for the table associated with that end.

Remarks

A relation object is an item in the data source view (DSV) to which a role or inheritance is bound.

See Also

Concepts

Model Designer
Model Designer Object Properties
Ad Hoc Reporting with Report Models
Working with Model Designer

Help and Information

Getting SQL Server 2005 Assistance