how to add index to column by script

Question

User-583959464 posted

using sql server 2017, may I know how to add index to nvarchar(max) column by script, any script reference?

or how to build a xml column and add index to xml column by script?

Answer 1

User503812343 posted

try this

CREATE NONCLUSTERED INDEX IDX_NC_temp_name ON tablename(idcolumn) INCLUDE(columnamewithnvarcharmax)