Task: Move the Employees table from the dbo schema to the HumanRwsources schema.
Solution I have: ALTER TABLE dbo.Employees ALTER SCHEMA HumanResources
The following 2 options are not correct:
ALTER TABLE dbo.Employees TRANSFER HumanResources
Explanation why this option is not correct: " should not use ALTER TABLE. It only allows the structure of the table not the schema that contains the table."
Question A: Why we cannot use ALTER TABLE here but it is okay to use it in the first answer (correct on above)?
ALTER SCHEMA HumanResources TRANSFER dbo.Employees
Question B: Why this answer is not correct? What the following code does anyway?