SYSEXTERNENVOBJECT system view

SQL Anywhere includes support for six external runtime environments. These include embedded SQL and ODBC applications written in C/C++, as well as applications written in Java, Perl, PHP, or languages such as C# and Visual Basic that are based on Microsoft's Common Language Runtime (CLR).

Each row in the SYSEXTERNENVOBJECT system view describes the installable external environment objects. The underlying system table for this view is ISYSEXTERNENVOBJECT.

Column name Column type Description
object_id unsigned bigint

A unique identifier for the external environment object.

extenv_id unsigned bigint

The unique identifier for the external environment (SYSEXTERNENV.object_id).

owner unsigned int

Identifies the creator/owner of the external environment object.

name long varchar

Identifies the name of the external environment object as specified in the INSTALL statement.

contents long binary

The contents of the external environment object.

update_time timestamp

Identifies the last time the object was modified (or installed).

Constraints on underlying system table

PRIMARY KEY (object_id)

FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL

FOREIGN KEY (extenv_id) references SYS.ISYSEXTERNENV (object_id)

FOREIGN KEY (owner) references SYS.ISYSUSER (user_id)