>>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)?
>
>All fields involved in PK are marked with key icon in the grid. Did you see such things?
>To see ALL indexes you could script the table, Right Click on Table name in TreeView and select Script Table as CREATE To.
>
It shows you I don't know much about SQl Server indexes (and other things too) <g>.
First, about Primary key. I am not sure I have one. When I created a table I set property of one of the columns as Identity Specification to Yes. I thought this automatically makes the column as Primary. Am I mistaken? If so, how do you do it?
When I script the table to a Query (as you suggested) the CREATE TABLE expression shows columns of the table, shows one column as IDENTITY and no indexes. Where would I see the "key icon in the grid"? I see no grid anywhere. Sorry for being so newbie on this.
Thank you 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