VistaDB 6
VistaDB.DDA Namespace / IVistaDBIndexCollection Interface
Members Example

In This Topic
    IVistaDBIndexCollection Interface
    In This Topic
    List of table's indexes
    Public Interface IVistaDBIndexCollection 
       Inherits VistaDB.DDA.IVistaDBKeyedCollection(Of String,IVistaDBIndexInformation) 
    Dim instance As IVistaDBIndexCollection
    public interface IVistaDBIndexCollection : VistaDB.DDA.IVistaDBKeyedCollection<string,IVistaDBIndexInformation>  
    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 

    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

    See Also