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 Microsoft 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 for Me (Login required).

Search for additional results

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