Synonyms

A synonym is an alias or alternate name for a table, view, sequence, or other schema object. HCL OneTest API 8.5.1 or later supports certain synonyms for some supported database management systems.

The following table lists the database management systems supported by HCL OneTest API and indicates the level of synonym support in 8.5.1 or later for each database.

Database management system (DBMS) Sequence synonym support Stored procedure synonym support Table synonym support Synonyms that point to other synonyms support

IBM® Db2® on distributed platforms (Linux, UNIX, and Windows)

Yes

(Not applicable)

Yes

Yes

Db2® on IBM® z/OS®

(Not applicable)

(Not applicable)

Yes

(Not applicable)

Microsoft SQL Server

No

Yes

Yes

No

MySQL

(Not applicable because MySQL does not support synonyms)

(Not applicable)

(Not applicable)

(Not applicable)

Oracle

Yes

Yes

Yes

Yes

Note: A synonym being learned becomes a entity in its own right in a database stub and is no longer a synonym for other content in the stub.