Question of the Day

Switching Schemas I

I run this query:

SELECT 
 s.name AS schemaname
 , o.name AS objectname
 FROM sys.objects o
 INNER JOIN sys.schemas s ON s.schema_id = o.schema_id
 WHERE o.name = 'Beer'

I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:

ALTER TABLE dbo.beer switch TO etl.beer

What happens?

See possible answers