Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 primary key change

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-16 : 08:16:16
Tara writes "Hi,
Is there a way to change the primary key of a table through a SQL statement? I have a table someone before me set up which had a username set as the primary key. I would like it to be changed to the password field I added to the table. However, we are unable to directly access the database due to some version problems, and as such have to go through a sql command line we built.

I would appreciate any light you may be able to shed on the problem.

Thanks"
   

- Advertisement -