而普通索引(非聚集索引)的语法,大多数数据库都是通用的:
CREATE INDEX Syntax CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,…
) [index_type] index_col_name: col_name [(length)] [ASC | DESC] index_type: USING {BTREE | HASH | RTREE} [java] view plaincopy — 创建无索引的表格 create table testNoPK ( id int not null, name varchar(10) )
; — 创建普通索引 create index IDX_testNoPK_Name on testNoPK (name);