|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.31 2001/11/10 20:13:37 tgl Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.32 2001/11/18 20:35:02 petere Exp $ |
3 | 3 | Postgres documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -161,22 +161,22 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable> |
161 | 161 | <para> |
162 | 162 | <command>ALTER TABLE</command> changes the definition of an existing table. |
163 | 163 | The <literal>ADD COLUMN</literal> form adds a new column to the table |
164 | | - using the same syntax as <xref linkend="SQL-CREATETABLE">. |
| 164 | + using the same syntax as <xref linkend="SQL-CREATETABLE" endterm="SQL-CREATETABLE-TITLE">. |
165 | 165 | The <literal>ALTER COLUMN SET/DROP DEFAULT</literal> forms |
166 | 166 | allow you to set or remove the default for the column. Note that defaults |
167 | 167 | only apply to subsequent <command>INSERT</command> commands; they do not |
168 | 168 | cause rows already in the table to change. |
169 | 169 | The <literal>ALTER COLUMN SET STATISTICS</literal> form allows you to |
170 | 170 | set the statistics-gathering target for subsequent |
171 | | - <xref linkend="sql-analyze"> operations. |
| 171 | + <xref linkend="sql-analyze" endterm="sql-analyze-title"> operations. |
172 | 172 | The <literal>RENAME</literal> clause causes the name of a table or column |
173 | 173 | to change without changing any of the data contained in |
174 | 174 | the affected table. Thus, the table or column will |
175 | 175 | remain of the same type and size after this command is |
176 | 176 | executed. |
177 | 177 | The ADD <replaceable class="PARAMETER">table constraint definition</replaceable> clause |
178 | 178 | adds a new constraint to the table using the same syntax as <xref |
179 | | - linkend="SQL-CREATETABLE">. |
| 179 | + linkend="SQL-CREATETABLE" endterm="SQL-CREATETABLE-TITLE">. |
180 | 180 | The DROP CONSTRAINT <replaceable class="PARAMETER">constraint</replaceable> clause |
181 | 181 | drops all constraints on the table (and its children) that match <replaceable class="PARAMETER">constraint</replaceable>. |
182 | 182 | The OWNER clause changes the owner of the table to the user <replaceable class="PARAMETER"> |
@@ -204,18 +204,18 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable> |
204 | 204 | You can use the <literal>SET DEFAULT</literal> form |
205 | 205 | of <command>ALTER TABLE</command> to set the default later. |
206 | 206 | (You may also want to update the already existing rows to the |
207 | | - new default value, using <xref linkend="sql-update">.) |
| 207 | + new default value, using <xref linkend="sql-update" endterm="sql-update-title">.) |
208 | 208 | </para> |
209 | 209 |
|
210 | 210 | <para> |
211 | 211 | In DROP CONSTRAINT, the RESTRICT keyword is required, although |
212 | 212 | dependencies are not yet checked. The CASCADE option is unsupported. |
213 | 213 | Currently DROP CONSTRAINT drops only CHECK constraints. |
214 | 214 | To remove a PRIMARY or UNIQUE constraint, drop the |
215 | | - relevant index using the <xref linkend="SQL-DROPINDEX"> command. |
| 215 | + relevant index using the <xref linkend="SQL-DROPINDEX" endterm="sql-dropindex-title"> command. |
216 | 216 | To remove FOREIGN KEY constraints you need to recreate |
217 | 217 | and reload the table, using other parameters to the |
218 | | - <xref linkend="SQL-CREATETABLE"> command. |
| 218 | + <xref linkend="SQL-CREATETABLE" endterm="sql-createtable-title"> command. |
219 | 219 | </para> |
220 | 220 | <para> |
221 | 221 | For example, to drop all constraints on a table <literal>distributors</literal>: |
|