List schemas in a database

This is an expansion of the sys.schemas table.
User schemas are sorted to the top, schema type is decoded, schema authorization is included.