Post reply

Why I can't insert a column in the table

  • February 6, 2013 at 1:51 pm

    #269871

    I got the following error:

    Saving changes is not permitted; The changes you made requires the following tables to be dropped and re-created. You have either made changes to the table that cannot be re-created or enabled the option of Prevent saving changes that require the table to be re-created.

    The column I tried to insert is a datetime and allow null

  • February 6, 2013 at 1:55 pm

    #1585128

    there's a GUI setting for when you Design a table that needs to be changed in this case:

    the GUI would drop and recreate, whereas a script might just ADD or Alter a column;

    it's a byproduct of the GUI being able to handle every possible change feature, it's easier to drop and recreate (which would lose any permissions applied to the table) than dynamically figure out if it can alter the table instead of drop and create.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 6, 2013 at 2:05 pm

    #1585130

    Thank you, that's the point

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply