System Views
SOLID Server supports views specified in the X/Open SQL Standard.
The COLUMNS system view identifies the columns which are accessible to the current user.
The SERVER_INFO system view provides attributes of the current database system or server.
Column name
Data type
Description
SERVER_ATTRIBUTE
VARCHAR
identifies an attribute of the server
ATTRIBUTE_VALUE
VARCHAR
the value of the attribute
The TABLES system view identifies the tables accessible to the current user.
System Tables
The SQL_LANGUAGES system table lists the SQL standards and SQL dialects which supported.
Column name
Data type
Description
PROPERTY
VARCHAR
the name of the property
VALUE_STR
VARCHAR
value as a string
VALUE_INT
INTEGER
value as an integer
Column name
Data type
Description
TARGET_ID
INTEGER
reserved for future use
SYNON
INTEGER
reserved for future use
SYS_TABLEMODES
Column name
Data type
Description
ID
INTEGER
relation id
MODE
VARCHAR
special mode info
MODIFY_TIME
TIMESTAMP
last modify time
MODIFY_USER
VARCHAR
last user that modified
This table is for systems internal use only.
SYS_TYPES
These tables are for the systems internal use only.
Copyright © 1992-1997 Solid Information Technology Ltd All rights reserved.