Exam 98-364 topic 1 question 99 discussion

A is correct! ALTER TABLE "table_name" Change "column 1" "column 2" ["Data Type"];

The correct answer is A. The ALTER command is a DDL command to modify the structure of existing tables in the database by adding, modifying, renaming, or dropping columns and constraints. Use the ALTER TABLE RENAME command to rename column names. Example: ALTER TABLE table_name RENAME COLUMN old_column_name TO new_column_name;

A.ALTER. That said, this is really for the sake of learning about DDL/DML etc, and it would be better if they could update that question to ask about removing a column rather than renaming a column. Reason is that those working using SQL Server Management Studio will use the EXEC sp_rename to rename a column as opposed to (I presume) MySQL, Oracle etc. I tried many combinations to rename a column in my Azure Data Studio using ALTER statements (tried ALTER COLUMN, MODIFY, RENAME, CHANGE etc) and nothing worked. Then I executed this sp_rename and it worked no problem - though we also need to be careful about renaming columns as it can affect stored procedures and other things apparently. Anyways, if anyone wants to try, they can find the full EXEC sp_rename statement here: https://docs.microsoft.com/en-us/sql/relational-databases/tables/rename-columns-database-engine?view=sql-server-ver15

None of the above, changing column should be done by using a procedure EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN'; reference : https://docs.microsoft.com/en-us/sql/relational-databases/tables/rename-columns-database-engine?view=sql-server-ver15