复制CREATE [UNIQUE] [CLUSTERED|NONCLUSTERED] INDEX <indexname> ON <tableorviewname>(<columnname> [ASC|DESC] [,数据...n]) INCLUDE (<columnname> [, ...n]) [WITH [PAD_INDEX = { ON | OFF }] [[,] FILLFACTOR = <fillfactor>] [[,] IGNORE_DUP_KEY = { ON | OFF }] [[,] DROP_EXISTING = { ON | OFF }] [[,] STATISTICS_NORECOMPUTE = { ON | OFF }] [[,] SORT_IN_TEMPDB = { ON | OFF }] [[,] ONLINE = { ON | OFF } [[,] ALLOW_ROW_LOCKS = { ON | OFF } [[,] ALLOW_PAGE_LOCKS = { ON | OFF } [[,] MAXDOP = <maximum degree of parallelism> ] [ON {<filegroup> | <partition scheme name> | DEFAULT }] 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.