SQL SERVER: Index Types

They are two types of indexes
1. Clustered Index

• Only one clustered index can be created on a table
• The physical storage of data in a table depends on the Clustered Index.
• A view with unique clustered index is called Indexed View

2. Non-Clustered Index

• 249 non-clustered indexes can be created on a single table

You need "Control" or "Alter" permission on that table to create a index.