Viewing an Index
After you have created indexes or PRIMARY KEY or UNIQUE constraints on tables, you may need to find information about the indexes. For example, you may need to find out the types of indexes and the columns that are indexes on a particular table or the total space in the database used by an index.
Each table registered for full-text indexing has one of its indexes selected as the full-text key. You can view the properties of an index to determine if an index is the full-text key.
To view the indexes on a table
Transact-SQLSQL Server Enterprise Manager can display the names of all the indexes in a database and the tables to which the indexes belong.
To view all indexes in a database