SAP Knowledge Base Article - Preview

2218311 - Column name and data type are concatenated after reversing SQL files - SAP PD

Symptom

  • After reverse engineering a SQL script, column name and data type have been concatenated.
  • The reversed table contains only one column.
  • The column name is embraced with square brackets.
    As an example,
       CREATE TABLE [dbo].[TABLE_1] (
       [COLUMN_1] bigint NOT NULL
       ) WITH (DATA_COMPRESSION=PAGE)
       GO
  • It works fine if the CREATE TABLE statement has multiple columns.


Read more...

Environment

  • SAP PowerDesigner (PD) 16.5 SP05 PL02
  • Microsoft SQL Server 2012

Product

SAP PowerDesigner 16.5

Keywords

Powerdesigner, reverse engineer, MSSQL, MS SQL, bracket, CR789872, CR#789872, 789872 , KBA , BC-SYB-PD , PowerDesigner , Known Error

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.