More on Alter
Explore SQL commands for altering table structures including renaming tables and modifying indexes after deployment. Understand how to use DROP TABLE and DROP DATABASE commands with the IF EXISTS clause to avoid errors when deleting tables or databases. This lesson equips you with practical skills to manage database objects safely and efficiently.
We'll cover the following...
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 ...