Schemas Catalog Views - sys.schemas
Applies to:
SQL Server
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
Contains a row for each database schema.
Note
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. |
Remarks
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.
Permissions
Requires membership in the public role.
See Also
Feedback
Submit and view feedback for