diff options
Diffstat (limited to 'doc/src/sgml/ref/create_table_as.sgml')
-rw-r--r-- | doc/src/sgml/ref/create_table_as.sgml | 117 |
1 files changed, 117 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml new file mode 100644 index 00000000000..01649be762a --- /dev/null +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -0,0 +1,117 @@ +<refentry id="CREATETABLEAS"> + <refmeta> + <refentrytitle> + CREATE TABLE AS + </refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + <refnamediv> + <refname> + CREATE TABLE AS + </refname> + <refpurpose> + Creates a new table + </refpurpose> + </refnamediv> + <refsynopsisdiv> + <refsynopsisdivinfo> + <date>1998-09-22</date> + </refsynopsisdivinfo> + <synopsis> +CREATE TABLE <replaceable>table</replaceable> [ (<replaceable>column</replaceable> [, ...] ) ] + AS <replaceable>select_clause</replaceable> + </synopsis> + + <refsect2> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> + Inputs + </title> + <para> + + <variablelist> + <varlistentry> + <term> + <replaceable>table</replaceable> + </term> + <listitem> + <para> + The name of a new table to be created. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term> + <replaceable>column</replaceable> + </term> + <listitem> + <para> + The name of a column. Multiple column names can be specified using +a comma-delimited list of column names. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term> + <replaceable>select_clause</replaceable> + </term> + <listitem> + <para> +A valid query statement. Refer to SELECT for a description of the +allowed syntax. + </para> + </listitem> + </varlistentry> + </variablelist> + </para> + </refsect2> + + <refsect2> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> + Outputs + </title> + <para> + Refer to CREATE TABLE and SELECT for a summary of possible output + messages. + </para> + </refsect2> + </refsynopsisdiv> + + <refsect1> + <refsect1info> + <date>1998-09-22</date> + </refsect1info> + <title> + Description + </title> + <para> +CREATE TABLE AS enables a table to be created from the contents of +an existing table. It has functionality equivalent to SELECT TABLE INTO, +but with perhaps a more obvious syntax. + </para> + </refsect1> +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:nil +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: +--> |