What should you create?

DRAG DROP
You execute the following code:

You discover that the Customers table was created in the dbo schema.
You need to create a code segment to move the table to another schema named Schema2.
What should you create?
To answer, drag the appropriate code segments to the correct location in the answer area.
(Answer choices may be used once, more than once, or not at all.)

DRAG DROP
You execute the following code:

You discover that the Customers table was created in the dbo schema.
You need to create a code segment to move the table to another schema named Schema2.
What should you create?
To answer, drag the appropriate code segments to the correct location in the answer area.
(Answer choices may be used once, more than once, or not at all.)

Answer:

Explanation:

http://msdn.microsoft.com/en-us/library/ms173423.aspx



Leave a Reply 2

Your email address will not be published. Required fields are marked *


xxx

xxx

alter schema schema2 transfer dbo.customers