Skip to main content
LukasPe1
Level 3
February 9, 2021
해결됨

Update database structure - many changes that are unexpected

  • February 9, 2021
  • 4 답변들
  • 1730 조회

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 

 

 

 

 

이 주제는 답변이 닫혔습니다.
최고의 답변: saikatk2447661

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

4 답변

saikatk2447661
Level 4
February 10, 2021

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

LukasPe1
LukasPe1작성자
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?)?