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.

Dropping directory access servers

To drop a directory access server (Sybase Central)

1. Connect to the 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.

To 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;

Dropping proxy tables

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

To drop a proxy table (Sybase Central)

1. Connect to the 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.

To 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

• DROP SERVER statement
• DROP TABLE statement