disconnect

Description

Drops the current connection to a database.

Syntax

disconnect [ connection_name | current | all ]
	connection_name : identifier , string, or hostvar

Parameters

connection_name

is the login name you are using to make the connection

current

indicates that you are disconnecting the current connection

all

indicates that you are disconnecting all connections

identifier

is the identifier you are using for the connection information

string

is the string you are using for the connection information

hostvar

is the variable information for the host name and port

Examples

Example 1

Disconnects all connections:

disconnect all

Usage

• disconnect drops a connection to the database server and releases all resources used by it. If the connection to be dropped was named on the connect statement, the name can be specified. Specifying all drops all of the application’s connections to all database environments. current is the default, and drops the current connection.

• An implicit rollback is executed on connections that are dropped.

Permissions

Any user can execute this command.

See also

connect, set connection

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF