Difference In Output Of Primary Key Columns Of DESC and INFO Commands (Doc ID 2967409.1)

Last updated on AUGUST 11, 2023

Applies to:

Symptoms

There is difference in sequencing column of table while using INFO <table> and DESC <table> command output when table has multiple columns in primary key.

For example

a. Create table t_emp ( empno number, no number, id number, ename varchar2(20));

b. Create a primary key for columns ( no. id, empno)

c.Check the command

desc t_emp

Name     Null?       Type
________ ___________ _______________
EMPNO    NOT NULL    NUMBER
NO       NOT NULL    NUMBER
ID       NOT NULL    NUMBER
ENAME                VARCHAR2(20)


 info t_emp

TABLE: T_EMP
         LAST ANALYZED:2023-08-10 23:00:15.0
         ROWS         :0
         SAMPLE SIZE  :0
         INMEMORY     :DISABLED
         COMMENTS     :

Columns
NAME         DATA TYPE           NULL  DEFAULT    COMMENTS
*EMPNO       NUMBER              No
*ID          NUMBER              No
*NO          NUMBER              No
 ENAME       VARCHAR2(20 BYTE)   Yes

Indexes
INDEX_NAME     UNIQUENESS    STATUS    FUNCIDX_STATUS    COLUMNS
______________ _____________ _________ _________________ ________________
HR.T_EMP_KY    UNIQUE        VALID                       NO, ID, EMPNO

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.