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.

Important

This feature has changed from earlier versions of SQL Server. For more information, see Breaking Changes to Database Engine Features in SQL Server 2005.

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.
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.

See Also

Reference

System Views (Transact-SQL)
Information Schema Views (Transact-SQL)
sys.databases (Transact-SQL)
sys.schemas (Transact-SQL)
sys.syscharsets (Transact-SQL)

Other Resources

Querying the SQL Server System Catalog

Help and Information

Getting SQL Server 2005 Assistance