Question

Command used to modify the schema is __________

(a) ALTER SCHEMA

(b) ALTER STRUCTURE

(c) ALTER VIEW

(d) DBCC SHRINKDB

I had been asked this question in an international level competition.

My question is from Data Definition Language in chapter Creating the Physical Database Schema of SQL Server

Answer 1

Right answer is (a) ALTER SCHEMA

Easy explanation: ALTER SCHEMA changes the owner of a schema.