DESCRIBE

The DESCRIBE statement obtains information about an object. You can obtain the following types of information with this statement, each of which is described separately.

  • Cursors

    Gets information about the result set that is associated with the cursor. This information, such as column information, is put into a descriptor. See DESCRIBE CURSOR.

  • Input parameter markers of a prepared statement.

    Gets information about the input parameter markers in a prepared statement. This information is put into a descriptor. See DESCRIBE INPUT.

  • The output of a prepared statement

    Gets information about a prepared statement or information about the select list columns in a prepared SELECT statement. This information is put into a descriptor. See DESCRIBE OUTPUT.

  • Procedures

    Gets information about the result sets returned by a stored procedure. The information, such as the number of result sets, is put into a descriptor. See DESCRIBE PROCEDURE.

  • Tables

    Gets information about a table or view. This information is put into a descriptor. See DESCRIBE TABLE.