试题详情
单项选择题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the Services schema， There is a table named Service.Table. The Services.Table has to be moved from the Sales schema to a new schema named Costs. In the options below， which Transact-SQL statement should you execute？（）

A、ALTER TABLE Service.Table SWITCH TO Costs.Table1; 

B、ALTER SCHEMA CostsTRANSFER Service.Table; 

C、ALTER USER Service WITH DEFAULT_SCHEMA = Costs; 

D、ALTER AUTHORIZATION ON Service.Table1 TO Costs;

  • B

  • 关注下方微信公众号，在线模考后查看

热门试题