DROP
CONNECTION Statement
Drops any user connection to the database.
Syntax
DROP CONNECTION <connection-id>
Parameters
- obtained using the connection_property function to request the connection number. This
statement returns the connection ID of the current connection:
SELECT connection_property( 'number' )
Examples
- drop connection with ID number 4:
DROP CONNECTION 4
Usage
You cannot drop your current connection; you must first create another connection, then drop your first connection.
Standards
- SQL—Vendor extension to ISO/ANSI SQL grammar.
- SAP Database products—Not supported by SAP ASE.