DESCRIBE
The DESCRIBE statement obtains information about an object.
The following types of information can be requested:
- Cursors
- Gets information about a cursor. The information, such as column information, is put into a descriptor. See DESCRIBE CURSOR.
- Input parameter markers of a prepared statement
- Gets information about the IN and INOUT 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. 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.