Drop Session

Summary

The DROP SESSION command allows developers to delete user sessions that exist in their Connect environment. The command will drop or delete the given session id from the Connect server. Any active queries will be terminated.

Syntax

drop session <session_id>;

Parameters

Parameter
Description
session_id
(Required) The unique identifier of the session to drop. Use SHOW SESSIONS to obtain a list of session_ids and other metadata for active sessions.

Details

The DROP SESSION result set includes the following columns:

Column Name
Data Type
Description
status_code string ‘0’ indicates success, ‘1’ failure
status_message string ‘ok’ indicates success, otherwise an error message
name string The session_id that was dropped.
command string ‘drop session’
count integer Default value for this command is ‘1’.
value string The session_id that was dropped.
exception_message string A more detailed message if an error occurred.

 

Examples

drop session 2c90941856a67e340157350370244ecc;

 

screen-shot-2016-09-19-at-1-14-54-pm

Related Commands

SHOW SESSIONS