SQL Server Transact Basic to Expert - Create an index in a table

This blog show how to create an index in a table

Syntax:

CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX indexname
    ON {
    [ databasename. [ schemaname].| schemaname. ]
        table or viewname}
(column [ ASC | DESC ] [ n ])