If the current database is an Oracle database or a SQL Server database, the following window is displayed when clicking the icon:

The information is displayed in different tabs.

Note: The information displayed in this window concerns all the users of the database (and not only the connected user).

Tab

Content

Tables

List the database tables created by the selected user (in the "User" combo box).The following information is displayed for each table:

The name of columns.

The HyperFileSQL type of columns. This type corresponds to the type used in WINDEV.

The Oracle type of columns. This type corresponds to the type of columns in Oracle.

The size of columns.

Views

List the database views created by the selected user (in the "User" combo box).The following information is displayed for each view:

The name of columns.

The HyperFileSQL type of columns. This type corresponds to the type used in WINDEV.

The Oracle type of columns. This type corresponds to the type of columns in Oracle.

The size of columns.

Synonyms

List the database synonyms visible by the selected user (in the "User" combo box).The following information is displayed for each synonym:

The visibility of the synonym.

The name of the synonym owner.

The name of the synonym.

The source name of the object.

The remote database to which the object belongs (if necessary).

Index

List the database indexes created by the selected user (in the "User" combo box).When selecting an index, the name of the columns associated with this index is displayed.

Procedures

List the database functions, packages and stored procedures created by the selected user (in the "User" combo box). The icon found in front of the name of a procedure indicates that the procedure contains at least one compilation error.You have the ability to create, modify or delete a stored procedure, a function or a package.To create a stored procedure (a function or a package), all you have to do is specify:

The name of the stored procedure (function or package).

The code of the stored procedure (function or package).

The stored procedure (function or package) is automatically created in the database and compiled. The list of compilation errors is displayed if necessary.Example for using a procedure: the syntax below is used to display the result of a function:

SELECT <FunctionName>(<Parameters>) from dual

Links (Oracle databases only)

List the different remote databases accessible from the database.The following information is displayed for each database:

The name of the owner of the remote database.

The name of the link used to access the remote database.

The connection string used by Oracle to access the remote database.

The visibility of the remote database.

Example: the syntax below is used to select the data found in a table of a remote database:

SELECT * from <TableName>@<LinkName>

Users

List the users defined on the database.The creation date and time are displayed for each user.

Structure of a database other than Oracle and SQL Server

If the current database is not an Oracle database or a SQL Server database, the following window is displayed when clicking the icon:

The information is displayed in different tabs.

Tab

Content

Tables

List the database tables.The following information is displayed for each table:

the name of columns,

the type of columns,

the size of columns.

Views

List the database views.The following information is displayed for each view: