## Synopsis

Use the `CREATE FOREIGN TABLE` command to create a foreign table.

## Syntax

{{%ebnf%}}
  create_foreign_table
{{%/ebnf%}}

## Semantics

Create a new foreign table named *table_name*. If *table_name* already exists in the specified database, an error will be raised unless the `IF NOT EXISTS` clause is used.

### Collation
The `COLLATE` clause can be used to specify a collation for the column.

### Server

The `SERVER` clause can be used to specify the name of the foreign server to use.

### Options:
The `OPTIONS` clause specifies options for the foreign table. The permitted option names and values are specific to each foreign data wrapper. The options are validated using the FDW’s validator function.

## Examples

Basic example.

```plpgsql
yugabyte=#  CREATE FOREIGN TABLE mytable (col1 int, col2 int) SERVER my_server OPTIONS (schema 'external_schema', table 'external_table');
```

## See also

- [`CREATE FOREIGN DATA WRAPPER`](../ddl_create_foreign_data_wrapper/)
- [`CREATE FOREIGN TABLE`](../ddl_create_foreign_table/)
- [`CREATE SERVER`](../ddl_create_server/)
- [`CREATE USER MAPPING`](../ddl_create_user_mapping/)
- [`IMPORT FOREIGN SCHEMA`](../ddl_import_foreign_schema/)
- [`ALTER FOREIGN TABLE`](../ddl_alter_foreign_table/)
- [`DROP FOREIGN TABLE`](../ddl_drop_foreign_table/)