|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface DB2Alias
A representation of the model object 'DB2 Alias'. SQL Reference for Cross-Platform Development - v1.1 http://www7b.software.ibm.com/dmdd/library/techarticle/0206sqlref/0206sqlref.html Aliases (Chapter 1. Concepts 9) An alias is an alternate name for a table or view. An alias can be used to reference a table or view in cases where an existing table or view can be referenced. However, the option of referencing a table or view by an alias is not explicitly shown in the syntax diagrams or mentioned in the description of SQL statements. Like tables and views, an alias may be created, dropped, and have a comment associated with it. No authority is necessary to use an alias. Access to the tables and views that are referred to by the alias, however, still requires the appropriate authorization for the current statement. An alias is created with the CREATE ALIAS statement. For more information about creating aliases, see " CREATE ALIAS" on page 318. CREATE ALIAS The CREATE ALIAS statement defines an alias for a table or view. Invocation: This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared. Authorization: The privileges held by the authorization ID of the statement must include at least one of the following: - The privilege to create in the schema - Administrative authority. Syntax: CREATE ALIAS alias-name FOR table-name view-name Description alias-name Names the alias. The name, including the implicit or explicit qualifier, must not be the same as an index, table, view or alias that already exists at the current server. If the alias-name is qualified, the schema name must not be a system schema. FOR table-name or view-name Identifies the table or view at the current server for which alias-name is defined. An alias name must not be specified (an alias cannot refer to another alias). An alias can be defined for an object that does not exist at the time of the definition. If it does not exist when the alias is created, a warning is returned. However, the referenced object must exist when a SQL statement containing the alias is used, otherwise an error is returned. Example: Create an alias named CURRENT_PROJECTS for the PROJECT table. CREATE ALIAS CURRENT_PROJECTS FOR PROJECT
The following features are supported:
DB2ModelPackage.getDB2Alias()
Method Summary | |
---|---|
org.eclipse.wst.rdb.internal.models.sql.tables.Table |
getAliasedTable()
Returns the value of the 'Aliased Table' reference. |
void |
setAliasedTable(org.eclipse.wst.rdb.internal.models.sql.tables.Table value)
Sets the value of the ' Aliased Table ' reference. |
Methods inherited from interface org.eclipse.wst.rdb.internal.models.sql.tables.Table |
---|
getColumns, getIndex, getSchema, getSelfRefColumnGeneration, getSubtables, getSupertable, getTriggers, getUdt, isInsertable, isUpdatable, setSchema, setSelfRefColumnGeneration, setSupertable, setUdt |
Methods inherited from interface org.eclipse.wst.rdb.internal.models.sql.schema.SQLObject |
---|
addEAnnotation, addEAnnotationDetail, getComments, getDependencies, getDescription, getEAnnotation, getEAnnotationDetail, getLabel, getPrivileges, removeEAnnotationDetail, setAnnotationDetail, setDescription, setLabel |
Methods inherited from interface org.eclipse.emf.ecore.sdo.EDataObject |
---|
getInstanceProperties |
Methods inherited from interface commonj.sdo.DataObject |
---|
createDataObject, createDataObject, createDataObject, createDataObject, createDataObject, createDataObject, delete, get, get, get, getBigDecimal, getBigDecimal, getBigDecimal, getBigInteger, getBigInteger, getBigInteger, getBoolean, getBoolean, getBoolean, getByte, getByte, getByte, getBytes, getBytes, getBytes, getChar, getChar, getChar, getContainer, getContainmentProperty, getDataGraph, getDataObject, getDataObject, getDataObject, getDate, getDate, getDate, getDouble, getDouble, getDouble, getFloat, getFloat, getFloat, getInt, getInt, getInt, getList, getList, getList, getLong, getLong, getLong, getSequence, getSequence, getSequence, getShort, getShort, getShort, getString, getString, getString, getType, isSet, isSet, isSet, set, set, set, setBigDecimal, setBigDecimal, setBigDecimal, setBigInteger, setBigInteger, setBigInteger, setBoolean, setBoolean, setBoolean, setByte, setByte, setByte, setBytes, setBytes, setBytes, setChar, setChar, setChar, setDataObject, setDataObject, setDataObject, setDate, setDate, setDate, setDouble, setDouble, setDouble, setFloat, setFloat, setFloat, setInt, setInt, setInt, setList, setList, setList, setLong, setLong, setLong, setShort, setShort, setShort, setString, setString, setString, unset, unset, unset |
Methods inherited from interface org.eclipse.emf.ecore.ENamedElement |
---|
getName, setName |
Methods inherited from interface org.eclipse.emf.ecore.EModelElement |
---|
getEAnnotations |
Method Detail |
---|
org.eclipse.wst.rdb.internal.models.sql.tables.Table getAliasedTable()
If the meaning of the 'Aliased Table' reference isn't clear, there really should be more of a description here...
setAliasedTable(Table)
,
DB2ModelPackage.getDB2Alias_AliasedTable()
void setAliasedTable(org.eclipse.wst.rdb.internal.models.sql.tables.Table value)
Aliased Table
' reference.
value
- the new value of the 'Aliased Table' reference.getAliasedTable()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |