Feedback:

← General

ALTER TABLE on live dataset, no exclusive required

I'd like to be able to do an alter table on a live data set. No exclusive access for ALTER TABLE.

96 votes
Vote 0 votes Vote Vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Forgot password?
    Create a password
    I agree to the terms of service

    You'll receive a confirmation email with a link to create a password (optional).

    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    jeremym1234jeremym1234 shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Forgot password?
      Create a password
      I agree to the terms of service

      You'll receive a confirmation email with a link to create a password (optional).

      Signed in as (Sign out)
      Close
      Close
      Submitting...
      • Ronald HoekRonald Hoek commented  ·   ·  Flag as inappropriate

        For option 2 you would suggest a field will actually have a default value....
        - But you've got a good point there ;)

      • FlorisoftFlorisoft commented  ·   ·  Flag as inappropriate

        1. Isn't there a way to do is with the help of online backup. First you do an online backup of the table, then that table is being altered, than the new records are copied also and then everything is copied back.
        2. Multiple record sizes in one table. So that you can alter a table only for the new records. The old records automatically returns the default value for a new field.

      General

      Knowledge Base and Helpdesk

      (thinking…)
      Reset