SCHEMATA (Transact-SQL)
SQL Server 2008 R2
Returns one row for each schema in the current database. To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA.view_name. To retrieve information about all databases in an instance of SQL Server, query the sys.databases (Transact-SQL) catalog view.
Column name | Data type | Description |
|---|---|---|
CATALOG_NAME | sysname | Name of current database |
SCHEMA_NAME | nvarchar(128) | Returns the name of the schema. |
SCHEMA_OWNER | nvarchar(128) | Schema owner name.  Important Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of an object is to query the sys.objects catalog view. |
DEFAULT_CHARACTER_SET_CATALOG | varchar(6) | Always returns NULL. |
DEFAULT_CHARACTER_SET_SCHEMA | varchar(3) | Always returns NULL. |
DEFAULT_CHARACTER_SET_NAME | sysname | Returns the name of the default character set. |
