The conversation between human and AI assistant.
Differentiate between ALTER table and Drop Table Command. What is the impact of both of these commands on table, with examples?
What would be an example of using ALTER table command?
For example, let's say you want to add a new column called 'phone_number' to an existing table called 'customers'. You can use the ALTER table command to add the column like this: ALTER TABLE customers ADD phone_number VARCHAR(20);