Update database structure - many changes that are unexpected | Community
Skip to main content
LukasPe1
LukasPe1
Level 3
February 9, 2021
Solved

Update database structure - many changes that are unexpected

  • February 9, 2021
  • 1 reply
  • 1709 views

Hi,

I have ran into this situation before but never understood why it happens.

Sometimes when I run the "Update database structure" I get very many changes on out of the box tables.
The generated SQL changes the DB definition of datetime fields.

 

Edit: This was caused by a change in the option WdbcUseTimeStampWithTZ. 

Thanks to @saikatk2447661 

 

 

 

 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by saikatk2447661

    I guess the temp table thing is happening because of the check box. Please try after unchecking it.

    1 reply

    saikatk2447661
    saikatk2447661Accepted solution
    Level 4
    February 10, 2021

    I guess the temp table thing is happening because of the check box. Please try after unchecking it.

      LukasPe1
      LukasPe1Author
      Level 3
      February 10, 2021
      Hi and thanks for your reply. Yes, exactly. But my question is more about what is triggering the change. Is this the WdbcUseTimeStampWithTZ option (or a combination with something else?)?
      Terms & ConditionsAccessibility statement

      Loading footer...