Navicat for SQLite index how to use

Navicat for SQLite as a powerful and comprehensive SQLite graphical user interface tool to provide users with complete server management functions, therefore, well received by everyone. But some novice users are not very familiar with this software, therefore, specifically in this to make some introductions. Let's share the following. How do I use the navicat for SQLite index?

Original: http://www.formysql.com/jiqiao/SQLite-suoyin.html

The Navicat for SQLite index provides faster access to table data, creates one or more columns, and accelerates the operation of the SQL statement on that table. Click on the "Index" icon to open the list of indexed objects.

Navicat for SQLite

Navicat for SQLite General properties

Type: The type of the index.

The Normal:normal index does not impose a limit on the column value.

The Unique:unique index guarantees that two rows of the table have no duplicate values in the key column.

Table name: The table that contains the index.

First Name: Defines the field.

Collation: Specifies the collation sequence that the column text item uses, and the default collation sequence is the collation sequence defined for the column. It is important to note that SQLite 3 is supported.

BINARY: Use MEMCMP () to compare string data regardless of text encoding.

Nocase: As with binary, except when running a pair, the ASCII 26 uppercase characters are collapsed to the corresponding lowercase, and only the ASCII character is case collapsed. Because of the size required by the table, SQLite does not try to do a full UTF case collapse.

RTRIM: As with binary, except for trailing whitespace characters are ignored.

Sort order: Indicates the sort order, that is, increment "asc" or decrement "desc".

About Navicat for SQLite index How to use the introduction is here, if there are any questions, you can focus on the relevant Navicat tutorial .

Navicat for SQLite index how to use