Neoview SQL Reference Manual (R2.4)

The ALTER TABLE statement changes a Neoview SQL table. See “Database Object Names”
(page 228).
ALTER TABLE name alter-action
ATTRIBUTE {NO INSERTLOG | INSERTLOG}
alter-action is:
ADD [COLUMN] column-definition
| ADD [CONSTRAINT constraint] table-constraint
| DROP CONSTRAINT constraint [RESTRICT | CASCADE]
| RENAME TO new name [CASCADE]
| ALTER COLUMN column-name SET basic-sequence-generator-option
column-definition is:
column data-type
([DEFAULT default | NO DEFAULT]
[[CONSTRAINT constraint-name] column-constraint]...)
data-type is:
CHAR[ACTER] [(length)[CHARACTERS]]
[CHARACTER SET char-set-name]
[UPSHIFT]
| PIC[TURE] X [(length)][CHARACTER SET char-set-name]
[DISPLAY] [UPSHIFT]
| CHAR[ACTER] VARYING (length)
[CHARACTER SET char-set-name]
[UPSHIFT]
| VARCHAR (length) [CHARACTER SET char-set-name]
[UPSHIFT]
| NUMERIC [(precision [,scale])] [SIGNED|UNSIGNED]
| NCHAR [(length) [CHARACTER SET char-set-name]
[UPSHIFT]
| NCHAR VARYING(length) [CHARACTER SET char-set-name]
[UPSHIFT]
| SMALLINT [SIGNED|UNSIGNED]
| INT[EGER] [SIGNED|UNSIGNED]
| LARGEINT
| DEC[IMAL] [(precision [,scale])] [SIGNED|UNSIGNED]
| PIC[TURE] [S]{ 9(integer) [V[9(scale)]] | V9(scale) }
[DISPLAY [SIGN IS LEADING] | COMP]
| FLOAT [(precision)]
| REAL
| DOUBLE PRECISION
| DATE
| TIME [(time-precision)]
| TIMESTAMP [(timestamp-precision)]
| INTERVAL { start-field TO end-field | single-field }
default is:
literal
| NULL
| CURRENT_DATE
| CURRENT_TIME
| CURRENT_TIMESTAMP}
basic-sequence-generator-option is:
internal-sequence-generator-increment-by-option
| internal-sequence-generator-maxvalue-option
internal-sequence-generator-increment-by-option is:
INCREMENT BY internal-sequence-generator-numeric-value
internal-sequence-generator-maxvalue-option is:
MAXVALUE internal-sequence-generator-numeric-value
internal-sequence-generator-numeric-value is:
signed-numeric-literal
46 SQL Statements