RelationalIndex question

Automate and integrate using the SQL comparison API

RelationalIndex question

Postby clamk123 » Mon Sep 10, 2012 6:42 pm

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.
clamk123
 
Posts: 29
Joined: Sun Apr 01, 2012 5:24 am

Postby Manfred.Castro » Wed Sep 12, 2012 9:23 pm

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);
}
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests