Create Index Tool

The Create Index Tool allows users to visually create indexes.

Note: RazorSQL does not provide the Create Index tool for all databases.

The Create Index Tool allows users to select a table on which to create an index and then specify the uniqueness of the index as well as the columns that make up the index.

The following is an example of the SQL generated from the Create Index Tool for a MySQL database

CREATE UNIQUE INDEX test_index ON sample.department (dnumber)

The following are links to information about the Create Index tool for some of the databases supported by RazorSQL:

DB2 Create Index
Derby Create Index
Firebird Create Index
FrontBase Create Index
HSQLDB Create Index
Informix Create Index
Ingres Create Index
MySQL Create Index
OpenBase Create Index
Oracle Create Index
PostgreSQL Create Index
MS SQL Server Create Index
SQLite Create Index
SQL Anywhere Create Index
Sybase Create Index