Schemas Catalog Views - sys.schemas
Applies to: SQL Server (all supported versions) Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
Contains a row for each database schema.
Database schemas are different from XML schemas, which are used to define the content model of XML documents.
|Column name||Data type||Description|
|name||sysname||Name of the schema. Is unique within the database.|
|schema_id||int||ID of the schema. Is unique within the database.|
|principal_id||int||ID of the principal that owns this schema.|
Database schemas act as namespaces or containers for objects, such as tables, views, procedures, and functions, that can be found in the sys.objects catalog view.
Each schema has a an owner. The owner is a security principal.
Requires membership in the public role.