Please, I need more help.

[tcarter]

Thanks for your help.

But can you provide source code based on the example I
gave?

Using the example below, I want to change the Primary Key
to SSN instead of Library_ID.

But, I want to keep Library_ID indexed. How is that done
through code.


Please read below! Thanks so much

-----Original Message-----
I need additional help with primary keys.

I have a table with three fields.

Mat_Lib_tbl
**************
1. SSN
2. LibraryID (PK)
3 Name


I want to programmatically change the table design to drop
the "LibraryID" as the primary key and assign the primary
key to be "SSN".

So that the alter table will look like this....

1. SSN (PK)
2. LibraryID
3. Name

How can this be done through code?
.

..