SAP Knowledge Base Article - Preview

3377776 - Can not define sort order in primary keys - SAP PD

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.