alter table

Hi, my tb1 already have a primary key, how to drop it and recreate a new one
is auto id primary? Please help...Here is a good post from Itzik Ben-Gan:
http://www.windowsitpro.com/Article...qlserver2005.de
--
"js" <js@.someone@.hotmail.com> schrieb im Newsbeitrag
news:Ob$nMZCTFHA.3464@.tk2msftngp13.phx.gbl...
> Hi, my tb1 already have a primary key, how to drop it and recreate a new
> one is auto id primary? Please help...
>

Alphanumeric Primary Key

Is it possible to have an auto increment alphanumeric primary key eg A1, A2, A3
Thanks
Paul.

There are two ways to create it and I have posted both in this thread, read my posts except the RDBMS history and you can create one. In ANSI SQL and Oracle it is called SEQUENCE. Hope this helps.
http://forums.asp.net/953564/ShowPost.aspx