DELETE-SQL-STREAM
Prev | SQL I/O Recording | Next

## Name

DELETE-SQL-STREAM — Remove a component from the broadcast streams used for recording SQL commands or results.Function

## Syntax

          delete-sql-stream stream &KEY type database => result

## Arguments and Values

`stream`

  A stream or `T`.

`stream`

  A stream or `T`.

`type`

  One of the following keyword symbols: :commands, :results or :both, defaulting to :commands.

`database`

  A database object. This will default to *default-database*.

`result`

  The added stream.

## Description

Removes the supplied stream `stream` from the recording broadcast stream for the SQL recording type specified by `type` on `database` which defaults to *default-database*. `type` must be one of :commands, :results, or :both, defaulting to :commands, depending on whether the stream is to be added for recording SQL commands, results or both.

## Examples

    (list-sql-streams :type :both)
    => (#<Stream for descriptor 7> #<Stream for descriptor 7>)
    (delete-sql-stream *standard-output* :type :results)
    => #<Stream for descriptor 7>
    (list-sql-streams :type :both)
    => (#<Stream for descriptor 7>)

## Side Effects

The specified broadcast stream(s) associated with `database` are modified.

## Affected by

None.

## Exceptional Situations

None.

## See Also

`start-sql-recording`
`stop-sql-recording`
`sql-recording-p`
`sql-stream`
`add-sql-stream`
`delete-sql-stream`
`list-sql-streams`

## Notes

None.

Prev | Up | Next
ADD-SQL-STREAM | Home | LIST-SQL-STREAMS