Database View Reference

Database View Reference

MRX_RT_SQLDS_DETAILS

MRX_RT_SQLDS_DETAILS

The MRX_RT_SQLDS_DETAILS view provides information about SQL data services with schema, virtual table, and virtual stored procedures in deployed applications.
The following table describes the columns in the MRX_RT_SQLDS_DETAILS view:
Column Name
Datatype
Description
DESIGN_APP_ID
NUMBER
Design-time application ID. The application is an object in the Developer tool.
SQLDS_ID
NUMBER
SQL data service ID.
SQLDS_NAME
VARCHAR(1536)
SQL data service name.
VSCHEMA_ID
NUMBER
Virtual schema ID.
VSCHEMA_NAME
VARCHAR(1536)
Virtual schema name.
VSCHEMA_DESC
VARCHAR(0)
Virtual schema description.
VT_ID
NUMBER
Virtual table ID.
VT_NAME
VARCHAR(1536)
Virtual table name.
VT_DESC
VARCHAR(0)
Virtual stored procedure description.

0 COMMENTS

We’d like to hear from you!