Symptom
- The ascending (ASC) or descending (DESC) sort order can not be specified in primary key (PK) in a Physical Data Model (PDM).
- The sort order value is ignored during reverse engineering.
- Example:
CREATE TABLE [Table_1](
[Column_1] [bigint] IDENTITY(1,1) NOT NULL,
[Column_2] [int] NOT NULL,
[Column_3] [varchar](200) NULL,
CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED
(
[Column_1] DESC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Read more...
Environment
- SAP PowerDesigner (PD) 16.7
- Microsoft SQL Server
Product
SAP PowerDesigner 16.7
Keywords
CR819259, CR#819259, 819259 , KBA , BC-SYB-PD , PowerDesigner , Product Enhancement
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.