Show Keys

The show keys command returns a result set listing any tables that have primary keys defined.

Syntax

show keys;

Table result set

Connect allows developers to create primary keys on custom tables. Refer to CREATE TABLE.

show keys;

showkeys_01

select *
from (show keys)
where schema_name = 'delta';

showkeys_02