IVistaDBIndexCollection Interface

In This Topic

List of table's indexes

Syntax

Visual Basic
C#

'Declaration
 
<System.Reflection.DefaultMemberAttribute("Item")>
Public Interface IVistaDBIndexCollection 
   Inherits VistaDB.DDA.IVistaDBKeyedCollection(Of String,IVistaDBIndexInformation)

'Usage
 
Dim instance As IVistaDBIndexCollection

[System.Reflection.DefaultMember("Item")]
public interface IVistaDBIndexCollection : VistaDB.DDA.IVistaDBKeyedCollection<string,IVistaDBIndexInformation>

Example

Through the DDA interfaces you can use this collection to determine if an index exists for a given table.

IVistaDBDatabase db = DDAUtils.BuildTestDatabase(ref DDAObj, dbname, false, null, false); 
IVistaDBTableSchema schema = db.TableSchema("Table1"); 
IVistaDBIndexCollection ixlist = schema.Indexes; 
if( ixlist["targetindex"] == null ) 
{ 
   // Index does not exist 
}

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

IVistaDBIndexCollection Members
VistaDB.DDA Namespace

Send Feedback