More on Alter
This lesson continues the discussion on altering various structures in a database.
We'll cover the following...
More on Alter
It is hard to predict what indexes to create without observing the access patterns for an application. We can add, remove, or modify indexes after the application is deployed. Note that modifying indexes doesn’t change the data in the table.
Example Syntax
ALTER TABLE oldTableName
RENAME ...