Undocumented SQL Server 7.0 System Tables



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)
4 = Page-level locking (PAGELOCK)
8 = Table Lock (TABLOCK)
16 = Exclusive table lock (TABLOCKX)
32 = Update lock (UPDLOCK)
64 = No lock (NOLOCK)
128 = Fast first-row option (FASTFIRST)
4096 = Read repeatable semantic when used with declare cursor (HOLDLOCK)

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
1 = Shared
3 = Update

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.


Continues…

Pages: 1 2 3 4




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |