Introduction
In this article, I want to tell you about undocumented system tables
shipped with SQL Server 7.0. These tables are used by some system
stored procedures and stored in the master database (only sysfiles1
system table is 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__
__ATLAS_TABLE_BLOCK__2__
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__
__ATLAS_TABLE_BLOCK__4__
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 sp_cursor_list system stored procedures to
report the attributes of server cursors currently open for the connection.
__ATLAS_TABLE_BLOCK__5__
__ATLAS_TABLE_BLOCK__6__
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__
__ATLAS_TABLE_BLOCK__8__
Contains one row for each file in a database. Each database contains
sysfiles1 system table.
__ATLAS_TABLE_BLOCK__9__
__ATLAS_TABLE_BLOCK__10__
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__11__
»
See All Articles by Columnist Alexander Chigrik