SAP Knowledge Base Article - Preview

2075164 - Changing column data type should generate ALTER TABLE statement – SAP PD 16.5

Symptom

SQL Server: When Modifying the data type of a column, PowerDesigner drops then recreates the table, although Miscrosoft SQL Server supports this syntax:

ALTER TABLE table_name
ALTER COLUMN column_name datatype


Read more...

Environment

  • SAP PowerDesigner (PD) 16.5
  • SAP PowerDesigner (PD) 16.5 SP04
  • Microsoft SQL Server DBMS

Product

SAP PowerDesigner 16.5 ; Sybase PowerAMC 16.5

Keywords

CR771746, 771746 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.