All,

I have the following requirement:

Table A exists.
Table B should be a replica of Table A (structurally).

The catch is this: Table B will have a Primary Key column and this column should be the first column, followed by all columns from Table A.

Is the above possible through SQL? If so, please provide some hints.
If not, please let me know ASAP, so that I can start scripting.

Thanks!
Suhas