Altering a table
Basic syntax for the ALTER TABLE command
Basic syntax for the ALTER TABLE command
- ALTER TABLE: The required ALTER TABLE keywords begin the DDL statement which allows you to modify an existing table.
- tablename: The tablename must identify an existing table. You may have to qualify the tablename with its schema name, as in schema.tablename
- ADD/MODIFY/DROP: The ADD, MODIFY, or DROP keywords specify the basic type of action you want to perform on the table.
- action_specific_syntax: The action specific_syntax can include a range of options, based on how you wish to modify the existing table structure.