VistaDB 5






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