apache > db
Apache DB Project
 
Font size:      

column-Name

column-Name

In many places in the SQL syntax, you can represent the name of a column by qualifying it with a table-Name or correlation-Name.

In some situations, you cannot qualify a column-Name with a table-Name or a correlation-Name, but must use a Simple-column-Name instead. Those situations are:

  • creating a table (CREATE TABLE statement)
  • specifying updatable columns in a cursor
  • in a column's correlation name in a SELECT expression (see SelectExpression)
  • in a column's correlation name in a TableExpression (see TableExpression)

Syntax

[ { table-Name | correlation-Name } . ] SQL92Identifier

Example

-- C.Country is a column-Name qualified with a
-- correlation-Name. 
SELECT C.Country
FROM APP.Countries C


Previous Page
Next Page
Table of Contents
Index