Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All


SQL Server 2000

Contains one row for each database that has permissions for the current user. The INFORMATION_SCHEMA.SCHEMATA view is based on the sysdatabases, sysconfigures, and syscharsets system tables.

To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA view_name.

Column name Data type Description
CATALOG_NAME sysname Name of the database where the current user has permissions.
SCHEMA_NAME nvarchar(128) Returns the name of the schema owner of object.
SCHEMA_OWNER nvarchar(128) Schema owner name.
DEFAULT_CHARACTER_SET_CATALOG varchar(6) Returns master, indicating the database where the default character set is defined.
DEFAULT_CHARACTER_SET_SCHEMA varchar(3) Returns DBO, indicating the name of the default character set owner.
DEFAULT_CHARACTER_SET_NAME sysname Returns the name of the default character set.

See Also




Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft