VistaDB 5
Members  Example 






VistaDB.DDA Namespace : IVistaDBIndexCollection Interface
IVistaDBIndexCollection Interface
List of table's indexes
Syntax
'Declaration
 
Public Interface IVistaDBIndexCollection 
   Inherits VistaDB.DDA.IVistaDBKeyedCollection(Of String,IVistaDBIndexInformation) 
'Usage
 
Dim instance As IVistaDBIndexCollection
public interface IVistaDBIndexCollection : VistaDB.DDA.IVistaDBKeyedCollection<string,IVistaDBIndexInformation>  
public interface IVistaDBIndexCollection = class(VistaDB.DDA.IVistaDBKeyedCollection)
public interface IVistaDBIndexCollection implements VistaDB.DDA.IVistaDBKeyedCollection 
public __gc __interface IVistaDBIndexCollection : public VistaDB.DDA.IVistaDBKeyedCollection<string,IVistaDBIndexInformation>  
public interface class IVistaDBIndexCollection : public 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

See Also