What are the challenges you face when working across database platforms? Take the survey
Options

RelationalIndex question

clamk123clamk123 Posts: 40
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.

Comments

  • Options
    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
Sign In or Register to comment.