The SHOW GENERIC command displays a complete or partial list of
    properties for the generic element or elements you specify.

    If you specify the type name but not an element name, the SHOW
    GENERIC command displays all elements of the specified type
    in your default directory, provided that you have privilege to
    display them.

    You must have read access to all components of the generic
    element for CDO to display those components.

    If you do not specify a version number for a generic element, CDO
    displays the highest visible version.

    You can display a field definition by specifying CDD$DATA_ELEMENT
    as the type name and the name of the field definition as the
    element name.

    You can display a record definition by specifying CDD$DATA_
    AGGREGATE as the type name and the name of the record definition
    as the element name.

    You can display indexes or constraints in an Oracle Rdb database
    element by specifying CDD$INDEX or CDD$CONSTRAINT as the type
    name and the name of the index or constraint as the element name.
    Remember to include the FROM DATABASE clause.