RelationalIndex question

clamk123

When trying to determine a primary key on a table, if you use the Index.PrimaryKey boolean it states that it is deprecated and that one should use the RelationalIndexes instead.

When I enumerate through the Relational indexes, it seems to have a 1-to-1 match to the indexes.

For example, if my indexes count is 4, my relational indexes is 4 as well.

So what is the definition of a "RelationalIndex"? I'm trying to associate which index is a primary key, which seems to be looking for PrimaryKey=True, but this appears deprecated, but it isn't clear what is the new way to find it.

Any assistance would be helpful.

Manfred.Castro

RelationalIndex.PrimaryKey Property

True if the index is a primary key.

Namespace: RedGate.SQLCompare.Engine
Assembly: RedGate.SQLCompare.Engine (in RedGate.SQLCompare.Engine.dll)

Syntax

Visual Basic (Declaration)

Public Property PrimaryKey As Boolean

C#

public bool PrimaryKey { get; internal set; }

Visual C++

public:
property bool PrimaryKey {
bool get ();
void set (bool value);
}