-
CTAS question
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|