Altering Tables

From InterBase

Go Up to Working with Tables

Use ALTER TABLE to modify the structure of an existing table. ALTER TABLE allows you to:

  • Add a new column to a table.
  • Drop a column from a table.
  • Drop integrity constraints from a table or column.
  • Modify the column name, data type, and position.

You can perform any number of the above operations with a single ALTER TABLE statement. A table can be altered by its creator, the SYSDBA user, and any users with operating system root privileges.

Any one table (and its triggers) can be altered at most 255 times before you must back up and restore the database.


Advance To: