TheALTER TABLEstatement is used to modify an existing database table structure. One common clause isCHANGE, which allows renaming a column and modifying its data type.
Example:
sql
ALTER TABLE Employees CHANGE COLUMN OldName NewName VARCHAR(50);
Option A (Incorrect):DELETE is used to removerows, not alter table structure.
Option B (Correct):CHANGE is avalid clausefor renaming and modifying columns in MySQL and some other databases.
Option C (Incorrect):STOP is not a valid SQL keyword for altering tables.
Option D (Incorrect):AGGREGATE refers to functions like SUM() and AVG(), not table alterations.
[Reference:SQL ALTER TABLE syntax in SE 3050 zyBooks., ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit