Drop directory access servers

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 (Sybase Central)

  1. Use the SQL Anywhere 12 plug-in to connect to the host database as a user with DBA authority.

  2. In the left pane, double-click Directory Access Servers.

  3. Select the directory access server, and then choose Edit » Delete.

 Drop a directory access server (SQL)

  1. Connect to the host database as a user with DBA authority.

  2. Execute a DROP SERVER statement.

    For example:

    DROP SERVER my_directory_server;

Use the DROP TABLE statement to drop a proxy table used by the directory access server.

 Drop a proxy table (Sybase Central)

  1. Use the SQL Anywhere 12 plug-in to connect to the host database as a user with DBA authority.

  2. In the left pane, double-click Directory Access Servers.

  3. In the right pane, click the Proxy Tables tab.

  4. Select the proxy table, and then choose Edit » Delete.

  5. Click Yes.

 Drop a proxy table (SQL)

  1. Connect to the host database as a user with DBA authority.

  2. Execute a DROP TABLE statement.

    For example:

    DROP TABLE my_files;
 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0