Symptom
After reverse engineering against MS SQL 2012, column name and data type have been concatenated.
This only appears to be a problem if there is one column in the table and the column name is embraced with square brackets.
CREATE TABLE [dbo].[CPC_SELLER_BUDGET_WORK] (
[GROUP_NO] bigint NOT NULL
) WITH (DATA_COMPRESSION=PAGE)
GO
PD shows "GROUP_NObigint" as a column name in the diagram.
If the create table statement has multiple columns it is reverse engineered correctly.
For example, if you reverse the following, both columns are created in PD.
CREATE TABLE [dbo].[CPC_SELLER_BUDGET_WORK] (
[GROUP_NO] bigint NOT NULL,
[GROUP2_NO2] bigint NOT NULL
) WITH (DATA_COMPRESSION=PAGE)
GO
Read more...
Environment
SAP PowerDesigner 16.5 SP05 PL02 and earlier.
Product
Keywords
Powerdesigner, reverse engineer, MSSQL, MS SQL, bracket , 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.