syntax for non clustered index in sql server code example Example: sql create index CREATE INDEX index_name ON tableName (tableColumn);