|
View previous topic :: View next topic
|
| Author |
Message |
pingte
Active User
Joined: 03 Dec 2005
Posts: 120
Location: india
|
|
|
|
i have a Table A with 4 cols : X,Y,Z,B
Now i am adding a column (M) to table A using ALTER command.
Criteria for insertion:
Columun M should be inserted between Z and M.
How can this be acheived? 
TIA,
Pingte |
|
| Back to top |
|
 |
muthuvel
Active User
Joined: 29 Nov 2005
Posts: 217
Location: Canada
|
|
|
|
| Quote: |
| Columun M should be inserted between Z and M. |
I think you want to say as M should be inserted between Z and B.
If that is the case,there is no point or no need of inserting between two columns.
Wherever you insert the column,it is going to be one row for a key record.Moreover you are going to use the column by it's dclgen . |
|
| Back to top |
|
|
pingte
Active User
Joined: 03 Dec 2005
Posts: 120
Location: india
|
|
|
|
| Quote: |
Columun M should be inserted between Z and B.
|
I just want to know whether it is feasible or not? |
|
| Back to top |
|
|
muthuvel
Active User
Joined: 29 Nov 2005
Posts: 217
Location: Canada
|
|
|
|
| The answer is NO. |
|
| Back to top |
|
|
deepak.vl
New User
Joined: 17 Feb 2007
Posts: 38
Location: Hyderabad
|
|
|
|
Hi,
In this case you may have to take the back up of the table data into another table/tape drive, drop the table, create the table with the new column between Z & B, load the new table with the backed up data. |
|
| Back to top |
|
|
|
|
