Search notes:

INFORMATION_SCHEMA.schemata

information_schema.schemata lists the available schemas.
select
   catalog_name,
   schema_name,
   schema_owner,
   default_character_set_catalog,
   default_character_set_schema,
   default_character_set_name
from
   information_schema.schemata;
Github repository about-MSSQL, path: /administration/schemas/INFORMATION_SCHEMA/schemata/select-all.sql

See also

sys.schemas
INFORMATION_SCHEMA

Index