Update database structure - many changes that are unexpected | Community
Skip to main content
LukasPe1
LukasPe1
New Participant
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
    New Participant
    February 10, 2021

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

      LukasPe1
      LukasPe1Author
      New Participant
      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...