Dawiso Exported Database Model

Views processing options

• On MS SQL Server, the views metadata may not be up-to-date Read more
• If the views metadata are not up-to-date, also the views column names in exported database model might be obsolete
• From this reason, option readDbModelViewColumns is added to analyzerOptions section of Input Definition JSON (not documented)
• if the option readDbModelViewColumns is true, the view columns are read at the beginning and processed like regular tables
• if the option readDbModelViewColumns is false (default and recommended)
  • Before processing
    • the views are created with only empty column lists.
    • external column "Id"s from db model are saved
  • During processing, the columns are inferred (autocreated) from view definition (CREATE VIEW AS SEELECT ...)
  • After processing, external "Id"s are restored for known columns