QSqlIndex Class

The QSqlIndex class provides functions to manipulate and describe database indexes. More...

Header: #include <QSqlIndex>
CMake: find_package(Qt6 COMPONENTS Sql REQUIRED)
target_link_libraries(mytarget PRIVATE Qt6::Sql)
qmake: QT += sql
Inherits: QSqlRecord

Public Functions

QSqlIndex(const QSqlIndex &other)
QSqlIndex(const QString &cursorname = QString(), const QString &name = QString())
QSqlIndex &operator=(const QSqlIndex &other)
~QSqlIndex()
void append(const QSqlField &field)
void append(const QSqlField &field, bool desc)
QString cursorName() const
bool isDescending(int i) const
QString name() const
void setCursorName(const QString &cursorName)
void setDescending(int i, bool desc)
void setName(const QString &name)

Detailed Description

An index refers to a single table or view in a database. Information about the fields that comprise the index can be used to generate SQL statements.

Member Function Documentation

QSqlIndex::QSqlIndex(const QSqlIndex &other)

Constructs a copy of other.

QSqlIndex::QSqlIndex(const QString &cursorname = QString(), const QString &name = QString())

Constructs an empty index using the cursor name cursorname and index name name.

QSqlIndex &QSqlIndex::operator=(const QSqlIndex &other)

Sets the index equal to other.

QSqlIndex::~QSqlIndex()

Destroys the object and frees any allocated resources.

void QSqlIndex::append(const QSqlField &field)

Appends the field field to the list of indexed fields. The field is appended with an ascending sort order.

void QSqlIndex::append(const QSqlField &field, bool desc)

This is an overloaded function.

Appends the field field to the list of indexed fields. The field is appended with an ascending sort order, unless desc is true.

QString QSqlIndex::cursorName() const

Returns the name of the cursor which the index is associated with.

See also setCursorName().

bool QSqlIndex::isDescending(int i) const

Returns true if field i in the index is sorted in descending order; otherwise returns false.

QString QSqlIndex::name() const

Returns the name of the index.

See also setName().

void QSqlIndex::setCursorName(const QString &cursorName)

Sets the name of the cursor that the index is associated with to cursorName.

See also cursorName().

void QSqlIndex::setDescending(int i, bool desc)

If desc is true, field i is sorted in descending order. Otherwise, field i is sorted in ascending order (the default). If the field does not exist, nothing happens.

See also isDescending().

void QSqlIndex::setName(const QString &name)

Sets the name of the index to name.

See also name().