Valid in: SQL

The HELP statement displays information about database objects and SQL statements, including object name, owner, and type for all tables, views, and indexes to which the user has access, and all synonyms owned by the user. System tables and temporary tables are not listed. Information is displayed in a one-line-per-object format.

In general, to display high-level information, specify HELP objectname (for example, HELP mytable). To display detailed information, specify HELP object_type object_name (for example, HELP TABLE mytable).

The asterisk wildcard character can be used in object name specifications to display information about a selected set of objects. For details, see Wildcards in Help Statement (see page Wildcards in Help Statement).