1
Download Informix Guide to SQL: Syntax
Transcript
ALTER TABLE Restrictions for Violations and Diagnostics Tables Keep the following considerations in mind when you use the ALTER TABLE statement in connection with violations and diagnostics tables: ■ You cannot add, drop, or modify a column if the table that contains the column has violations and diagnostics tables associated with it. ■ You cannot alter a violations or diagnostics table. ■ You cannot add a constraint to a violations or diagnostics table. See the START VIOLATIONS TABLE statement on page 1-584 for further information on violations and diagnostics tables. ADD Clause ADD Clause Add Column Clause ADD , ( Add Column Clause ) Add Column Clause new column name Element column name new column name 1-48 Data Type p. 1-664 DEFAULT Clause p. 1-51 Purpose The name of a column before which the new column is to be placed The name of the column that you are adding Informix Guide to SQL: Syntax New Column Constraint Definition p. 1-54 BEFORE column name Restrictions The column must already exist in the table. Syntax Identifier, p. 1-723 You cannot add a SERIAL column if the table contains data. Identifier, p. 1-723
