syscursortables |
Contains the base tables referenced by a server cursor. This table is stored in the master database. The syscursortables table is used by the sp_describe_cursor_tables system stored procedures to report the base tables referenced by a server cursor.
Column name |
Data type |
Description |
cursor_handle |
int |
A unique value for the cursor within the scope of the server. |
table owner |
sysname, nullable |
User ID of the table owner. |
table_name |
sysname, nullable |
Name of the base table. |
optimizer_hints |
smallint |
Bitmap consisting of one or more of: 1 = Row-level locking (ROWLOCK) |
lock_type |
smallint |
Scroll-lock type requested either explicitly or implicitly for each base table that underlies this cursor. The value can be: 0 = None |
server_name |
sysname, nullable |
Name of the linked server the table resides on. NULL if OPENQUERY or OPENROWSET are used. |
objectid |
int |
Object ID of the table. 0 if OPENQUERY or OPENROWSET are used. |
dbid |
int |
ID of the database the table resides in. 0 if OPENQUERY or OPENROWSET are used. |
dbname |
sysname, nullable |
Name of the database the table resides in. NULL if OPENQUERY or OPENROWSET are used. |
sysfiles1 |
Contains one row for each file in a database. Each database contains a sysfiles1 system table.
Column name |
Data type |
Description |
status |
int |
For internal use only. |
fileid |
smallint |
File identification number unique for each database. |
name |
nchar(128) |
Logical name of the file. |
filename |
nchar(260) |
Name of the physical device, including the full path of the file. |