Results 1 to 3 of 3

Thread: Alter table

  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Alter table

    Hi to all!
    I have a silly problem, but I'm not able to solve it!
    I know how to add a field in a table via Enterprise manager and I know also via ALTER TABLE command.
    ...But the problem is: I want to add a field NOT in the last position, but on the middle (for istance)
    So, this is possible via Enterprise Manager but with the ALTER TABLE command? How can I add a field without put it in the last position?
    ...Thanks a lot!
    Sergio

    p.s.: Sorry for my poor english..I hope you understand my question!

  2. #2
    Join Date
    Nov 2003
    Posts
    94
    Do it in enterprise manager->design table, click on the little scroll with briefcase icon (thirs on the tool bar) and copy the generated SQL code from there, and exit design without saving.

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    Originally posted by HanafiH
    Do it in enterprise manager->design table, click on the little scroll with briefcase icon (thirs on the tool bar) and copy the generated SQL code from there, and exit design without saving.
    THANKS A LOT! I SOLVED MY PROBLEM!..

    I never take care about icons ...........bur from NOW I will consider IT!
    Once again thank you!
    Sergio

Posting Permissions

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