VistaDB 6
VistaDB.DDA Namespace / IVistaDBTable Interface / CreateIndex Method
Index name
Key expression with syntax "column1[;DESC(column2)[;...n]]". Key expression cannot cover more than 256 columns.
The index is the primary key.
The index requires unique column constraint. It is ineffective parameter when primary parameter is set (because all primary keys MUST be unique by definition).


In This Topic
    CreateIndex Method
    In This Topic
    Create an index on current table. This may be a unique constrained index, or a primary key index.
    Syntax
    'Declaration
     
    
    Sub CreateIndex( _
       ByVal name As System.String, _
       ByVal keyExpression As System.String, _
       ByVal primary As System.Boolean, _
       ByVal unique As System.Boolean _
    ) 
    'Usage
     
    
    Dim instance As IVistaDBTable
    Dim name As System.String
    Dim keyExpression As System.String
    Dim primary As System.Boolean
    Dim unique As System.Boolean
     
    instance.CreateIndex(name, keyExpression, primary, unique)
    void CreateIndex( 
       System.string name,
       System.string keyExpression,
       System.bool primary,
       System.bool unique
    )

    Parameters

    name
    Index name
    keyExpression
    Key expression with syntax "column1[;DESC(column2)[;...n]]". Key expression cannot cover more than 256 columns.
    primary
    The index is the primary key.
    unique
    The index requires unique column constraint. It is ineffective parameter when primary parameter is set (because all primary keys MUST be unique by definition).
    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