Unique Properties - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

Unique Properties

The Unique Properties area of the Properties dialog box displays the values of the unique properties of the selected element.

You can view the unique properties of an element, but you cannot change them. The unique properties vary depending on the type of element being viewed.

 

Table 6: Unique Properties for Relationships 

Box or Checkbox

Description

OriginClassID

Displays the Origin Class Name.

DestClassID

Displays the Destination Class Name.

Unique Name

If selected, MDS validates that all objects added to the collection of this Relationship have a unique name.

PropagateDelete

If selected, children of the relationship will be deleted if the origin object is deleted.

VersioningSupport

This property indicates the current version status of the class objects; it appears only if the repository is versioned.

 

Table 7: Unique Properties for Properties 

Box or Checkbox

Description

PropertyType

Displays the SQL data type of the Property object.

PropertySize

Displays the Size, in characters, of the Property object if a character type or the number of digits, if size is a numeric type.

PropertyDigits

Displays the number of digits to the right of the decimal point for a numeric Property object.

PropertyID

Displays the Relative Property ID assigned to the property object.

VariantType

Describes the COM type, which determines the format of the field for MDS to use to get and set the field.

CharacterSet

Displays the name of the character set assigned to the property object.

DerivedProperty

If active, signals that this is a derived property.

RelationshipsToProperty

Explains how the derived property was obtained from the base property.

BasePropertyName

Displays the name of the property the property was derived from.

IsRequired

If checked, the property is required.

PropertyDefaultValue

The value assigned to the property when the application provides no value for the property.

 

Table 8: Unique Properties for Classes 

Box or Checkbox

Description

PropagateDelete

If selected, children of the class will be deleted if the origin object is deleted.

Serial

Every time a property is added or removed from a class, the serial of the class is incremented by 1. The initial serial of a class is 1.

Unique Name

If checked, MDS validates that all the objects in the Class have a unique name.

DerivedClass

If checked, signals that this class is a derived class.

BaseClassID

If this is a derived class, displays the object ID for the class from which this class was derived.

AbstractClass

If checked, signals that this is an abstract class.

SuperClasses

Super classes are classes that the selected class inherits from.

VersioningSupport

This property indicates the current version status of the class objects; it appears only if the repository is versioned.

DescriptionRequired

If checked, requires a description for the class.

 

Table 9: Unique Properties for Objects 

Group

Element

Description

 

 

Name

The Unique Properties area, lists the name of each unique property for the object.

Value

The field next to each name displays the value associated with the property.

Display of selected property value

 

When a list of properties is displayed, it can be difficult to see the entire value in the list display.

Highlighting the property name will display its value in this larger box with scroll bars.