Database Migration v1 API - Class ConstraintEntity (2.1.0)

public sealed class ConstraintEntity : IMessage<ConstraintEntity>, IEquatable<ConstraintEntity>, IDeepCloneable<ConstraintEntity>, IBufferMessage, IMessage

Reference documentation and code samples for the Database Migration v1 API class ConstraintEntity.

Constraint is not used as an independent entity, it is retrieved as part of another entity such as Table or View.

Inheritance

object > ConstraintEntity

Namespace

Google.Cloud.CloudDms.V1

Assembly

Google.Cloud.CloudDms.V1.dll

Constructors

ConstraintEntity()

public ConstraintEntity()

ConstraintEntity(ConstraintEntity)

public ConstraintEntity(ConstraintEntity other)
Parameter
NameDescription
otherConstraintEntity

Properties

CustomFeatures

public Struct CustomFeatures { get; set; }

Custom engine specific features.

Property Value
TypeDescription
Struct

Name

public string Name { get; set; }

The name of the table constraint.

Property Value
TypeDescription
string

ReferenceColumns

public RepeatedField<string> ReferenceColumns { get; }

Reference columns which may be associated with the constraint. For example, if the constraint is a FOREIGN_KEY, this represents the list of full names of referenced columns by the foreign key.

Property Value
TypeDescription
RepeatedFieldstring

ReferenceTable

public string ReferenceTable { get; set; }

Reference table which may be associated with the constraint. For example, if the constraint is a FOREIGN_KEY, this represents the list of full name of the referenced table by the foreign key.

Property Value
TypeDescription
string

TableColumns

public RepeatedField<string> TableColumns { get; }

Table columns used as part of the Constraint, for example primary key constraint should list the columns which constitutes the key.

Property Value
TypeDescription
RepeatedFieldstring

TableName

public string TableName { get; set; }

Table which is associated with the constraint. In case the constraint is defined on a table, this field is left empty as this information is stored in parent_name. However, if constraint is defined on a view, this field stores the table name on which the view is defined.

Property Value
TypeDescription
string

Type

public string Type { get; set; }

Type of constraint, for example unique, primary key, foreign key (currently only primary key is supported).

Property Value
TypeDescription
string