Toad World® Forums

What different between tab primary key and tab indexes in viewer table

Hello
What different between tab primary key and tab index?
My Table HRTPERSON had primary key (person_pk) when i click tab primary key in viewer table it didn't display anything.

thank
Somporn Nakwong

index_01.jpeg

index_02.jpeg

Hello Somporn,

The primary key tab should only show the primary keys and the index tab should show all indexes including the primary key.

I believe there is an error with the SQL when fetching the primary key list. Could you please tell me what the locking scheme for table HRTPERSON is? You can quickly see this in the script and/or properties tab.

Thanks.

Hell MichaelG
This table is locked by data rows.

Thanks
Somporn

Hello Somporn,

We created CR 84,408 for this issue and it will be fixed in the next beta.

Thanks.