VistaDB 6
VistaDB.DDA Namespace / IVistaDBTableSchema Interface / DefineIndex Method
Index name
Key expression - Columns to be included in the index
Is this the primary index. All primary key indexes must be unique.
The index unique. Has no effect if primary flag has been set


In This Topic
    DefineIndex Method
    In This Topic
    Define new index entry in table schema or update the existing one
    Syntax
    'Declaration
     
    
    Function DefineIndex( _
       ByVal name As System.String, _
       ByVal keyExpression As System.String, _
       ByVal primary As System.Boolean, _
       ByVal unique As System.Boolean _
    ) As IVistaDBIndexInformation
    'Usage
     
    
    Dim instance As IVistaDBTableSchema
    Dim name As System.String
    Dim keyExpression As System.String
    Dim primary As System.Boolean
    Dim unique As System.Boolean
    Dim value As IVistaDBIndexInformation
     
    value = instance.DefineIndex(name, keyExpression, primary, unique)
    IVistaDBIndexInformation DefineIndex( 
       System.string name,
       System.string keyExpression,
       System.bool primary,
       System.bool unique
    )

    Parameters

    name
    Index name
    keyExpression
    Key expression - Columns to be included in the index
    primary
    Is this the primary index. All primary key indexes must be unique.
    unique
    The index unique. Has no effect if primary flag has been set

    Return Value

    Instance of new IVistaDBIndexInformation
    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