## Synopsis

Use the `ALTER FOREIGN DATA WRAPPER` command to alter the definition of the foreign-data wrapper. This command can be used to alter the handler/validator functions or the options of the foreign-data wrapper. It can also be used to change the owner or rename the foreign-data wrapper.

## Syntax

{{%ebnf%}}
  alter_foreign_data_wrapper
{{%/ebnf%}}

## Semantics

Alter the foreign-data wrapper named **fdw_name**.

### Handler

The `HANDLER` clause can be used to specify the handler function.
The `NO HANDLER` clause can be used to specify that the foreign-data wrapper has no handler function.

### Validator

The `VALIDATOR` clause can be used to specify the validator function.
The `NO VALIDATOR` can be used to specify that the foreign-data wrapper has no validator function.

### Options

The `OPTIONS` clause can be used to specify the new options of the foreign-data wrapper. `ADD`, `SET`, and `DROP` specify the action to be performed. `ADD` is assumed if no operation is explicitly specified.

The new owner of the FDW can be specified using **new_owner**

The new name of the FDW can be specified using **new_name**

## Examples

Change the handler to `newhandler`.

```plpgsql
yugabyte=# ALTER FOREIGN DATA WRAPPER my_wrapper HANDLER;
```

Alter the foreign-data wrapper to have no validator.

```plpgsql
yugabyte=# ALTER FOREIGN DATA WRAPPER my_wrapper NO VALIDATOR;
```

Alter the foreign-data wrapper's options: add `new` and set it to `'1'`, change the value of `old` to `'2'`.

```plpgsql
yugabyte=# ALTER FOREIGN DATA WRAPPER my_wrapper OPTIONS(ADD new '1', SET old '2');
```

## See also

- [`CREATE FOREIGN DATA WRAPEPR`](../ddl_create_foreign_data_wrapper/)
- [`DROP FOREIGN DATA WRAPPER`](../ddl_create_foreign_data_wrapper/)