<!--
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_external_table.sgml,v 1.105 2006/09/16 00:30:17 momjian Exp $
PostgreSQL documentation
-->

<refentry id="SQL-ALTEREXTERNALTABLE">
 <refmeta>
  <refentrytitle id="sql-alterexternaltable-title">ALTER EXTERNAL TABLE</refentrytitle>
  <refmiscinfo>SQL - Language Statements</refmiscinfo>
 </refmeta>

 <refnamediv>
  <refname>ALTER EXTERNAL TABLE</refname>
  <refpurpose>change the definition of an external table</refpurpose>
 </refnamediv>

 <indexterm zone="sql-alterexternaltable">
  <primary>ALTER EXTERNAL TABLE</primary>
 </indexterm>

 <refsynopsisdiv>
<synopsis>
ALTER EXTERNAL TABLE name RENAME [COLUMN] column TO new_column

ALTER EXTERNAL TABLE name RENAME TO new_name

ALTER EXTERNAL TABLE name SET SCHEMA new_schema

ALTER EXTERNAL TABLE name action [, ... ]

where action is one of:
  ADD [COLUMN] column_name type
  DROP [COLUMN] column
  ALTER [COLUMN] column TYPE type [USING expression]
  OWNER TO new_owner

</synopsis>

 </refsynopsisdiv>

 <refsect1 id="SQL-ALTEREXTERNALTABLE-description">
  <title>Description</title>
  
  <para>
    
  </para>
  

</refsect1>

 <refsect1>
  <title>Parameters</title>
   
   </refsect1>

 <refsect1 id="SQL-ALTEREXTERNALTABLE-notes">
  <title>Notes</title>

   
</refsect1>


 <refsect1 id="SQL-ALTEREXTERNALTABLE-examples">
  <title>Examples</title>

  
</refsect1>

 <refsect1>
  <title>See Also</title>

  
 </refsect1>
</refentry>