One of the most curious things about SQL server is that it keeps its own system data in the same kind of database format and schema that you as the end user utilizes. The ability to look into the system’s database is very useful to developers. Being able to programmatically examine your things like a list of databases existing on the server or even the individual columns within serves lots of useful purposes.