ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-22
System Tables in All Databases
syslogs – – – – –
sysobjects x name x VARCHAR
(60)
The fully qualified SQL Server
object name in uppercase
letters.
id x INT (4) An object ID used internally by
the NonStop ODBC Server.
uid x INT (2) A user ID used internally by the
NonStop ODBC Server.
type x CHAR (2) A code indicating the object
type:
N NonStop SQL/MP catalog
table or NonStop ODBC
Server mapping table
S System table view
T Temporary table
UUser table
VView
userstat – – Assigned -1
sysstat – – Assigned -1
indexdel – – Assigned -1
schema – – Assigned -1
refdate – – Assigned “ ” (blank)
crdate x DATETIME Date and time the object was
created.
expdate – – Assigned “ ” (blank)
deltrig – – Assigned -1
instrig – – Assigned -1
updtrig – – Assigned -1
seltrig – – Assigned -1
category – – Assigned -1
Table B-7. NonStop ODBC Server Support of System Tables in All
Databases (page 3 of 5)
Columns
Table Name NonStop ODBC Server Support Column Name NonStop ODBC Server Support Data Type Comments or Value Assigned
xIndicates a supported table or column
–Indicates an unsupported table or column