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.