sys.schemas (Transact-SQL)
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. |
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
