Creating SQL Objects › Altering a Table

Altering a Table

Use the ALTER TABLE statement to change a table definition without manually reloading it. You can change one of the table's column definitions and/or the table's constraints in a single statement. You can make only one change to a column in the ALTER TABLE statement.

You can perform the following with this statement:

• Define a new column. (The columns in the table are defined as FIELD occurrences in CA Datacom Datadictionary.)
• Define new table constraints.
• Drop constraints, columns, foreign keys or primary keys. (see the sections starting with Column Constraint Definition.)
• Modify a column definition.
• Rename a column.

Enter the ALTER TABLE statement in the numbered area of an EDIT Source Member Panel. See How to Submit SQL Statements for the steps to obtain the panel and an explanation of the fields on the panel. See ALTER TABLE for information and the syntax of the statement.