[ http://issues.apache.org/jira/browse/DERBY-335?page=all ] Satheesh Bandaram closed DERBY-335: -----------------------------------
This new feature has been in Derby since 10.1. > Enhance Derby by adding SYNONYM support. A synonym is an alternate name for a > view or a table. > ---------------------------------------------------------------------------------------------- > > Key: DERBY-335 > URL: http://issues.apache.org/jira/browse/DERBY-335 > Project: Derby > Type: New Feature > Components: SQL > Versions: 10.1.1.0 > Environment: Generic > Reporter: Satheesh Bandaram > Assignee: Satheesh Bandaram > Fix For: 10.1.1.0 > Attachments: synonym.patch.jira > > Synonym provides an alternate name for a table or a view that is present in > the same schema or another schema. A synonym can also be created for another > synonym, causing nesting of synonyms. A synonym can be used in SELECT, > INSERT, UPDATE, DELETE or LOCK TABLE statements instead of the original > qualified table or view name. Note that a synonym can be created for a table > or a view that doesn't yet exists. But the target table/view must be present > before the synonym can be used. > Synonyms are supported by all major database vendors, including Oracle, DB2 > and mySQL. DB2 also allows CREATE ALIAS statement, which does exactly same as > CREATE SYNONYM. Creating aliases instead of synonyms is not supported by > Oracle or mySQL, so I propose that Derby not support creating aliases. > Synonyms are not part of SQL-2003 spec, but is a common-SQL statement among > major database vendors. SQL standard doesn't pay attention to DDLs as much, > so I suspect they skipped synonyms. > I will be adding two new DDL statements to Derby: > CREATE SYNONYM <SynonymSchema>.<SynonymName> FOR <TargetSchema>.<TargetName> > DROP SYNONYM <SynonymSchema>.<SynonymName> > Synonyms share the same namespace as tables or views. It is not possible to > create a synonym with same name as a table that already exists in the same > schema. Similarly, a table/view can't be created that matches a synonym > already present. -- 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
