Microsoft
70-432 · Question #122
You administer a SQL Server 2008 instance that contains a database named DB1. A table named Sales.Table1 exists in the Sales schema. You need to move the Sales.Table1 table to a new schema named…
The correct answer is A. ALTER SCHEMA Billing TRANSFER Sales.Table1. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 instance that contains a database named DB1. A table named Sales.Table1 exists in the Sales schema. You need to move the Sales.Table1 table to a new schema named Billing. Which Transact-SQL statement should you execute?
Options
- AALTER SCHEMA Billing TRANSFER Sales.Table1;
- BALTER USER Sales WITH DEFAULT_SCHEMA = Billing;
- CALTER AUTHORIZATION ON Sales.Table1 TO Billing:
- DALTER TABLE Sales.Table1 SWITCH TO Billing.Table1;
How the community answered
(18 responses)- A72% (13)
- B17% (3)
- C6% (1)
- D6% (1)
Community Discussion
No community discussion yet for this question.