diff options
Diffstat (limited to 'doc/src/sgml/ref/alter_table.sgml')
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index a9fc887c778..94343f88f6e 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -490,10 +490,12 @@ ALTER TABLE <replaceable class="PARAMETER">name</replaceable> <term><replaceable class="PARAMETER">name</replaceable></term> <listitem> <para> - The name (possibly schema-qualified) of an existing table to - alter. If <literal>ONLY</> is specified, only that table is - altered. If <literal>ONLY</> is not specified, the table and any - descendant tables are altered. + The name (optionally schema-qualified) of an existing table to + alter. If <literal>ONLY</> is specified before the table name, only + that table is altered. If <literal>ONLY</> is not specified, the table + and all its descendant tables (if any) are altered. Optionally, + <literal>*</> can be specified after the table name to explicitly + indicate that descendant tables are included. </para> </listitem> </varlistentry> @@ -877,7 +879,7 @@ ALTER TABLE distributors DROP CONSTRAINT zipchk; </para> <para> - To remove a check constraint from a table only: + To remove a check constraint from one table only: <programlisting> ALTER TABLE ONLY distributors DROP CONSTRAINT zipchk; </programlisting> |