SCHEMATA (Transact-SQL)

SCHEMATA (Transact-SQL)

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Language Filter

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (October 2009)

SCHEMATA (Transact-SQL)

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 or use the OBJECT_SCHEMA_NAME function.
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.

Examples

The following example returns information about each schema in the database.

USE AdventureWorks;
GO

SELECT *
FROM INFORMATION_SCHEMA.SCHEMATA;

Reference

Other Resources

Help and Information