Dropping directory access servers (SQL)

Administrators can use Interactive SQL to delete directory access servers.

Prerequisites

DBA authority.

Context and remarks

You cannot alter an existing directory access server: you must drop the existing directory access server using a DROP SERVER statement, and then create a new one.

 Drop a directory access server
  1. Connect to the host database.

  2. Execute a DROP SERVER statement.

    For example:

    DROP SERVER my_directory_server;

Results

The directory access server is deleted.

Next

Drop any proxy tables associated with the directory access server.

 See also

Dropping proxy tables (Sybase Central)