ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-33
ALTER TABLE
ALTER TABLE
Use ALTER TABLE to add new columns to an existing table. The new column appears
as the last column of the table.
The ALTER TABLE statement has the following syntax:
table-name
is the table to alter. The table name can be qualified with the database name and
owner name. The fully expanded table name must be unique in the network.
column-identifier
is the column to add. The column identifier must be unique for columns defined in
the table.
If the statement contains errors, the results can be different than if executed using
ODBC. See the following discussion of “Adding Multiple Columns.”
DROP INDEX Removes an index. DROP INDEX
DROP TABLE Removes a table, along with all data,
indexes, dependent views, and permission
specifications for that table.
DROP TABLE
DROP VIEW Removes views. DROP VIEW
DML Statements
DELETE Removes rows from a table. DELETE
INSERT Adds new rows to a table or view. INSERT
SELECT Retrieves rows from tables. SELECT
UPDATE Changes data in existing rows, either by
adding new data or modifying existing
data.
UPDATE
Stored Procedure Execution Statement
CALL Invokes a stored procedure (a Pathway
server class).
None
ALTER TABLE table-name
[ ADD column-identifier data-type ]
[ ADD ( column-identifier data-type ]
[ [, column-identifier data-type] ... ) ]
Table 3-9. Supported CORE SQL Statements by Type (page2of2)
CORE SQL
Statement Description
Corresponding NonStop
SQL/MP Statement