2976292 - Generate Alter Column..Drop Default DDL for Microsoft SQL Server DBMS - SAP PD

• The physical data model (PDM) has MS SQL Server 2017 as the target DBMS. A table has columns with default values defined. If you delete the default values and execute modify database, PD will generate DDL that drops and recreates the table.
• However, SQL Server supports the following syntax as well:

ALTER TABLE <table name>

ALTER COLUMN <column name> DROP DEFAULT;

• Can the MS SQL Server 2017 XDB be modified to support the alter syntax instead of dropping the table?

SAP PowerDesigner (PD) 16.7

MS, PDM, physical datamodel , KBA , BC-SYB-PD , PowerDesigner , Problem