>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.