PrepAway - Latest Free Exam Questions & Answers

Which Transact-SQL statement should you execute?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
ALTER SCHEMA Billing TRANSFER Sales.Table1;

B.
ALTER USER Sales WITH DEFAULT_SCHEMA = Billing;

C.
ALTER AUTHORIZATION ON Sales.Table1 TO Billing:

D.
ALTER TABLE Sales.Table1 SWITCH TO Billing.Table1;


Leave a Reply