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 ])