Introduction
In this article, I want to tell you about undocumented system tables
shipped with SQL Server 2000. These tables are used by some system
stored procedures and stored in the master database (only sysfiles1,
sysproperties and sysfulltextnotify system tables are stored in each
database).Undocumented System Tables
syscursorcolumns |
|---|
Contains the list of server cursor’s columns. This table is stored
in the master database. syscursorcolumns table is used by
sp_describe_cursor_columns system stored procedure to report the
attributes of the columns in the result set of a server cursor.
__ATLAS_TABLE_BLOCK__1__syscursorrefs |
|---|
Contains one row for each server cursor. This table is stored in the
master database and contains cursor name, cursor scope (local
or global) and cursor handler. syscursorrefs table is used by
sp_describe_cursor, sp_describe_cursor_columns,
sp_describe_cursor_tables and sp_cursor_list system
stored procedures to get cursor name, cursor scope and cursor handler.
__ATLAS_TABLE_BLOCK__3__
Advertisement
syscursors |
|---|
Contains the attributes of a server cursor. This table is stored in the
master database. syscursors table is used by
sp_describe_cursor system stored procedures to report the attributes
of a server cursor and by sp_cursor_list system stored procedures to
report the attributes of server cursors currently open for the connection.
__ATLAS_TABLE_BLOCK__5__syscursortables |
|---|
Contains the base tables referenced by a server cursor. This table
is stored in the master database. syscursortables table is
used by
sp_describe_cursor_tables system stored procedures to report the
base tables referenced by a server cursor.
__ATLAS_TABLE_BLOCK__7__sysfiles1 |
|---|
Contains one row for each file in a database. Each database contains
sysfiles1 system table.
__ATLAS_TABLE_BLOCK__9__sysfulltextnotify |
|---|
Contains full-text catalog’s notifications. sysfulltextnotify table
is
used by sp_fulltext_database, sp_fulltext_catalog,
sp_fulltext_table
and sp_fulltext_column system stored procedures.
Each database contains sysfulltextnotify system table.
__ATLAS_TABLE_BLOCK__11__syslocks |
|---|
Contains information about active locks. This table is provided for
backward compatibility only, and replaced by syslockinfo.
__ATLAS_TABLE_BLOCK__13__sysproperties |
|---|
Contains extended properties that can be defined on various objects
in a database. The extended properties is a new SQL Server 2000
feature. These extended properties can be used to store a caption
for a table, view, or column, to store an input mask for a column,
to store the formatting rules for displaying the data in a column,
and so on. sysproperties table is used by sp_droptype,
sp_validatepropertyinputs, sp_addextendedproperty,
sp_updateextendedproperty, sp_dropextendedproperty
and sp_revokedbaccess system stored procedures to manage
extended properties, and by fn_listextendedproperty system
function to retrieve the value of an existing extended property.
Each database contains sysproperties system table.
__ATLAS_TABLE_BLOCK__15__
Advertisement
sysxlogins |
|---|
Contains each Windows NT account or group name and each SQL Server
login name. This table is stored in the master database.
__ATLAS_TABLE_BLOCK__17__