detect primaryKeys for nested Tables

Hi!
i found the following example for a nested table:

CREATE TYPE ProjectType AS OBJECT(

    pno NUMBER,
    pname CHAR(31),
    budget NUMBER);
CREATE TYPE ProjectSet AS TABLE OF ProjectType;  

CREATE TABLE Dept (dno NUMBER, dname CHAR(31), projs ProjectSet)

    NESTED TABLE projs STORE AS

        ProjectSetTable ((Primary Key(Nested_Table_Id, pno)) ORGANIZATION
INDEX COMPRESS 1); My Question is: how can i find out the primaryKey-Columns? I am building an application that should show that these columns (in this case 'nested_table_id' and 'pno' are primaryKeys. I have the other data of the nested table (via the ALL_NESTED_TABLES - table) but i dont know where i can the information about the primaryKeys.
Plz help,
Carsten Received on Tue Sep 25 2001 - 17:08:59 CEST