What is a "schema provider" in an RDBMS?
Could someone please define what is meant by a schema provider? I'm familiar with DB schema (in this context, I take them to mean a named, logical container for DB objects). Why would a schema provider be useful? From a high level, how do they operate? The context here is SQL Server 2008. ...