VistaDB 5






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
DefineIndex Method
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
)
function DefineIndex( 
    name: System.String;
    keyExpression: System.String;
    primary: System.Boolean;
    unique: System.Boolean
): IVistaDBIndexInformation; 
function DefineIndex( 
   name : System.String,
   keyExpression : System.String,
   primary : System.boolean,
   unique : System.boolean
) : IVistaDBIndexInformation;
IVistaDBIndexInformation* DefineIndex( 
   System.string* name,
   System.string* keyExpression,
   System.bool primary,
   System.bool 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