1.0

• Can contain only unicode letters and digits, or underscore characters ( _ )
• Must begin with an alphabetic character
• Should have a minimum length of one byte and a maximum of 128 bytes
• Are case-insensitive (use delimited identifiers for case-sensitive)
• Cannot contain quotation marks or spaces
• Cannot be a reserved word
Delimited identifiers are those enclosed within double quotation (") marks. If the identifier itself needs to have
a double quotation mark then two consecutive double quotation marks should be used.
The following conventions are used in the syntax definitions in the remaining document:
• Square brackets ([]) are used to enclose optional items.
• Braces ({}) are used to group items and is not part of syntax as such.
• A star (*) denotes that the preceding item can be repeated 0 or more number of times.
• A pipe (|) is for ORing different elements i.e. one of the ORed items are needed.
• An explicit bracket, brace, star or pipe will be shown enclosed in single quotes e.g. '*' . Parentheses have no
special meaning and are always literals.
SQL Statements
Learn about the supported statements provided in this release of VMWare vFabric SQLFire.
Each reference page provides the statement syntax, describes custom extensions, and shows examples of using
the statement.
ALTER TABLE
Use the ALTER TABLE statement to add columns and constraints to a table, remove them from a table, and
modify other table features such as AsyncEventListener implementations and gateway sender configurations.
You perform table modifications only on non-primary key columns that are not used for table partitioning.
Many table modifications can be performed only before you add data to the table. After you add rows to the
table, you cannot use ALTER TABLE clauses even if you first delete the data. The following clauses are
exceptions to this rule:
• You can use the ALTER COLUMN column-name SET GENERATED ALWAYS AS IDENTITY clause after
loading data into a table to resume generating GENERATED ALWAYS identity column values.
• You can ADD or DROP constraints using the CONSTRAINT, UNIQUE, CHECK, or FOREIGN KEY clauses
after you have added data to a table.
Syntax
ALTER TABLE table-name
{
ADD COLUMN Column Definition |
ADD Table Constraint on page 453 |
ALTER [COLUMN] column-name SET GENERATED ALWAYS AS IDENTITY |
DROP [ COLUMN ] column-name [ RESTRICT ] |
DROP { PRIMARY KEY | FOREIGN KEY constraint-name | UNIQUE
constraint-name | CHECK constraint-name | CONSTRAINT constraint-name }
|
SET EVICTION MAXSIZE integer-constant |
SET GATEWAYSENDER ( [sender-name] [, sender-name] * ) |
vFabric SQLFire User's Guide432
vFabric SQLFire Reference