From 31176cd686f31dcb71392f6583f7b8d9cef63770 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Tue, 14 May 2024 21:16:19 +0200 Subject: Adding upstream version 16.3. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/sql-altertable.html | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'doc/src/sgml/html/sql-altertable.html') diff --git a/doc/src/sgml/html/sql-altertable.html b/doc/src/sgml/html/sql-altertable.html index dc4e185..09c7616 100644 --- a/doc/src/sgml/html/sql-altertable.html +++ b/doc/src/sgml/html/sql-altertable.html @@ -1,5 +1,5 @@ -ALTER TABLE
ALTER TABLE
Prev UpSQL CommandsHome Next

ALTER TABLE

ALTER TABLE — change the definition of a table

Synopsis

+ALTER TABLE
ALTER TABLE
Prev UpSQL CommandsHome Next
ALTER TABLE
ALTER TABLE — change the definition of a table
Synopsis
 ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
     action [, ... ]
 ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
@@ -113,7 +113,7 @@ WITH ( MODULUS numeric_literal, REMAIN
 
 exclude_element in an EXCLUDE constraint is:
 
-{ column_name | ( expression ) } [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
+{ column_name | ( expression ) } [ COLLATE collation ] [ opclass [ ( opclass_parameter = value [, ... ] ) ] ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
 
 referential_action in a FOREIGN KEY/REFERENCES constraint is:
 
@@ -1096,4 +1096,4 @@ ALTER TABLE measurement
    ALTER TABLE DROP COLUMN can be used to drop the only
    column of a table, leaving a zero-column table.  This is an
    extension of SQL, which disallows zero-column tables.
-  
See Also
CREATE TABLE
Prev Up Next
ALTER SYSTEM Home ALTER TABLESPACE

\ No newline at end of file
+

See Also

CREATE TABLE
Prev Up Next
ALTER SYSTEM Home ALTER TABLESPACE
\ No newline at end of file -- cgit v1.2.3