add uniqueidentifier field to existing table 1

[Lost500]

Hi all!

I need an unique id field that automatically adds an id number to every record that gets added.

I have a SQL Database on SQL server 2005.

I think the solution is to add uniqueidentifier fields to the tables in a database. all the tables already have data in them I don't know if that matters.

Also, what settings in the uniqueidentifier field do i have to set inorder for the id num to be automatically populated.

Thanks in advance!!!

 

[markros]

In order for them to automatically populate put NewID() in the default value for the column.

 

[markros]

See also if this thread183-1548439 can be helpful.

 

[TysonLPrice]

You could create a new table with an identity, copy the old table into it, drop the old table, and then rename it.

create table #TableTwo(PK Int Identity, column1 varchar(5),column2 Varchar(5))

Insert into #TableTwo
select column1,column1 from #TableOne 

drop table #tableone

Then rename it from SQL Server Management Studio or via SP-Rename.