DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Adding column.

  1. #11
    Join Date
    Aug 2001
    Posts
    267
    How about the solution I mentioned ..It didn't work???
    Raghu

  2. #12
    Join Date
    Jul 2000
    Posts
    147
    Raghu:

    Thanks! I will try that. This is what I did and worked so far…

    Export the table.
    Drop the table.
    Recreate the table with new columns.
    Import the data.

  3. #13
    Join Date
    Aug 2001
    Posts
    267
    Yes you can do that .. But creating another table from the existing table ..Drop the original and rename the temp to orginal is sofast ..

    I tried before I gave you this solution

    Just insert dummy column, alias it name you want

    create table test1 as select row1,' ' dummy,row2 from test;
    Raghu

  4. #14
    Join Date
    Jul 2000
    Posts
    147
    Raghu:

    Thanks…Work great!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width