2.1.11. ALTERing

  • Schema evolution
  • Design side
  • ALTER TABLE <schema_name>.<relation_name> ADD
    <var_name> <var_type>;
  • Example
    • ALTER TABLE uni.student ADD hall VARCHAR(32);
  • Upper and lower case syntax
  • Naming conventions