1. I want to create a couple of index keys for a table. At this point I want to learn how to do it using SQL Server Management Studio, visually. I opened SQLSMS, go to my database, to the table. Then I clicked on Table Designer menu and on the Indexes/Keys item. The Indexes/Keys window is empty. And I thought I would see at least on index key there, for the Primary key (as I read in the BOL that SQL Server automatically creates a clustered index for a Primary key in a table). If not in this window, where do you see the clustered index keys (that are automatically created by SQL Server)?
2. Then I clicked on Add button of the Indexes/Keys window. SQLSMS automatically creates an index for the primary key, naming it IX_MYPRIMKEY. My question is, if a clustered index on the Primary key is already exist, does it make sense to delete this index?
3. It looks like SQLSMS names indexes with a prefix IX_. How important it is to maintain this convention?
4. When I created an index on any column the value in Data Space Specification is always PRIMARY. What does it mean?
Thank you in advance for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
