Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    Unanswered: Positioning an added column...

    how do I position a newly added column in the table?
    the default is at the very end.

    what would I have to add to this code:

    ALTER TABLE Vehicles
    ADD Model varchar(55)

    Last edited by sabastious; 01-28-04 at 01:31.

  2. #2
    Join Date
    Jan 2003
    you can not change the position of the newly added coulmn from QA, it can only be done through EM. But why would you care to change the sequence of the columns? it is to be taken care in the query.

  3. #3
    Join Date
    Jul 2003
    Penang, Malaysia
    I never seen such a command before, I don't think there is...
    What is the diff???
    The sequence of the columns in the table is not the finalize version...
    You can still use "select statment " to position your columns for viewing.

    Else if you really want to do it, do it through Enterprise Manager, design table, in between the columns you want it to be position, right click and click "insert column".
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

Posting Permissions

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