| 1. | Altering Database Tables: Add a Column | | |
| 2. | Altering Database Tables: Add More Columns | | |
| 3. | Altering Database Tables: Drop a Column | | |
| 4. | Altering Database Tables: Drop Unique Constraint and Add Primary Key | | |
| 5. | Alter table: add unique | | |
| 6. | Alter table: drop primary and foreign key | | |
| 7. | Alter table: add primary key, foreign key and add column | | |
| 8. | Altering and Dropping Tables | | |
| 9. | Alter table to change the auto_increment setting and comments | | |
| 10. | Alter table to change the order | | |
| 11. | Alter table to add column | | |
| 12. | Alter table to change column sequence | | |
| 13. | Alter table to add columns | | |
| 14. | Alter table to drop primary key | | |
| 15. | Alter table to drop foreign key | | |
| 16. | Changing the Table Design (ALTER TABLE) | | |
| 17. | Use ALTER TABLE to change the column type | | |
| 18. | The Effect of ALTER TABLE on Null and Default Value Attributes | | |
| 19. | Create the table and then set the initial sequence value with ALTER TABLE | | |
| 20. | Alter table to set the primary key start | | |
| 21. | ALTER TABLE statement modifies the table accordingly | | |
| 22. | Alter table to add primary key, add new column, change column, drop column | | |
| 23. | Using ALTER TABLE command to add the names_num column to the cust_names table | | |
| 24. | Two ALTER TABLE statements can be combined | | |
| 25. | Alter table to add foreign key | | |
| 26. | Syntax for Altering a Column | | |
| 27. | Syntax for altering table and delete a Column | | |
| 28. | Storing Altered Character Strings | | |
| 29. | To drop a default value, use ALTER col_name DROP DEFAULT: | | |
| 30. | ALTER column to BINARY | | |
| 31. | Use the asterisk to try matching against the name ian or the alternative spelling, iain. | | |
| 32. | Specifying Multiple Alterations | | |
| 33. | Alter table to add an index | | |
| 34. | Alter table to add unique index | | |
| 35. | Alter table to Delete an Index | | |
| 36. | Alter table to add index | | |
| 37. | To drop an index with ALTER TABLE | | |
| 38. | Reduce the number of significant characters per index in the index to the first 16 characters | | |
| 39. | Add IGNORE to the statement, then use SELECT to have a look at the table contents to see how the duplicates ha | | |
| 40. | Change j from INT to BIGINT | | |
| 41. | MODIFY statement should specify the null and default value attributes explicitly | | |
| 42. | Redefine i to be NOT NULL, then try again | | |
| 43. | Change column definition | | |