SQL::TableInfo::AddIndex()

Syntax

Column_Number as N = <SQL::TableInfo>.AddIndex( Index as SQL::IndexInfo )

Argument	Description
Column_Number	The column number of the new index column.
<SQL::TableInfo>	A SQL::TableInfo object.
<Index>	A SQL::IndexInfo object.

Description

The AddIndex() method adds a new index definition to a table definition. Names must not duplicate ("" counts as a name).

Examples

dim TableInfo as SQL::TableInfo

dim IndexInfo as SQL::IndexInfo

dim IndexColumn as SQL::IndexColumnInfo

TableInfo.Name = "MyTable"

IndexInfo.Name = "Primary_Key"

IndexInfo.PrimaryKey = .t.

IndexColumn.Name = "MyColumnName"

? IndexInfo.AddColumn(IndexColumn)

= .T.

? TableInfo.AddIndex(IndexInfo)

= 1