Symptom
- 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?
Read more...
Environment
SAP PowerDesigner (PD) 16.7
Product
SAP PowerDesigner 16.7
Keywords
MS, PDM, physical datamodel , KBA , BC-SYB-PD , PowerDesigner , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.