Tag Archives: scheme

MSSQL – Selecting from objects listed from sp_help and getting “invalid object name”

Earlier this week I was looking up some tables in SSMS via alt+f1 (the sp_help command) and got invalid object. It was baffling me for several minutes until I looked in object explorer and had a different scheme name.

Goes to show you that the Owner value isn’t always the same as scheme, of course that makes sense as they are 2 different things: owner is more so for security and scheme is a separate location or container for db objects  🙂