While every SQL term can be used in many ways to accomplish different goals, ALTER may be the most complex. In general, ALTER is used to change the structure of a table, by:
Table B.2 lists some of the common ALTER clauses, all of which would begin with the phrase ALTER TABLE tablename. For example: ALTER TABLE my_table ADD COLUMN my_column INT UNSIGNED ALTER TABLE my_table DROP INDEX my_index
|