Lowell,

Thanks for the reply,

There are no foreign keys to other tables from this identity column.

But, there are foreign keys to other tables on other columns in this table like User_id, Time_id.

so i would like to avoid dropping the table and creating a new table and possibly have things go wrong and damage any relationships with other tables from the other columns.

Thanks

Leroy