db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Resolved: (DERBY-78) Add support for table/view Synonym to Derby
Date Tue, 14 Jun 2005 18:44:53 GMT
     [ http://issues.apache.org/jira/browse/DERBY-78?page=all ]
     
Satheesh Bandaram resolved DERBY-78:
------------------------------------

    Resolution: Duplicate

This is a duplicate of DERBY-335.

> Add support for table/view Synonym to Derby
> -------------------------------------------
>
>          Key: DERBY-78
>          URL: http://issues.apache.org/jira/browse/DERBY-78
>      Project: Derby
>         Type: New Feature
>   Components: SQL
>     Versions: 10.0.2.0
>  Environment: Generic
>     Reporter: Satheesh Bandaram
>     Assignee: Satheesh Bandaram

>
> A table synonym is an alternative name for a table or a view. A table or view can be
referred to in an SQL statement by its name or by its synonym. A synonym can be created even
if the object does not exist. Synonyms refer to a table, view, or another synonym within the
same database.
> The effect of using a synonym in an SQL statement is similar to that of text substitution.
Synonym, which must be defined by the time that an SQL statement is compiled, is replaced
at statement compilation time by the qualified base table or view name.
> Two new SQL statements will be added to Derby, CREATE SYNONYM and DROP SYNONYM.
> CREATE SYNONYM DEPARTMENT.A1 FOR SALES.T1
> DROP SYNONYM DEPARTMENT.AI
> Databases like Oracle, DB2 and mySQL have this capability and it would be nice to add
this to Derby. The syntax conforms to latest SQL standard.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message