HOPEX Data Governance > Data Architecture and Tools > Generating SQL scripts > Supported Syntax > CREATE INDEX Instruction (Oracle, Sybase, SQL Server)
CREATE INDEX Instruction (Oracle, Sybase, SQL Server)
Definition of an index
An index is a set of columns in a table for which a direct access is defined.
For Sybase and SQL Server, the value of the index-type attribute for the index determines what type of index is generated: UNIQUE, CLUSTERED, or UNIQUE CLUSTERED.
Processing and generating SQL commands
For each index a clause is generated as a function of the target DBMS.
For Oracle:
CREATE INDEX (column1,..., columnN) [TABLESPACE (TbSpaceName)
(column1, ..., columnN) represent the columns in the index; TbSpaceName is the name of the tablespace for the indexes (see Configuring SQL generation).
For Sybase and SQL Server:
CREATE [UNIQUE] [CLUSTERED] INDEX (IndexName) (TableName) (column1,..., columnN)
(column1, ..., columnN) represent the columns in the index; TbSpaceName is the name of the tablespace for the indexes (see Configuring SQL generation).
CREATE VIEW Clause
A view is defined for a database. It can include one or more tables.
CREATE VIEW view-name
AS
SELECT
(column-name,column-name,...)
You can enhance this definition in the view specification (see Defining Database Views).