>that's why asking for "append from" like command with no need to defined the columens name.
>
>thanks

Since you are adding an identity column, the following will work (after creating the new table):

insert into NewTable select * from OldTable

This will not work if the added column is not an identity column.