or if you are lazy to list the column name do this.

SELECT NEWID() AS [NewID], * INTO NewTable

FROM ExistingTable;

ALT_R TABLE NewTable DR_P COLUMN OldID

*fill in the blank