Column Name

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page Data Types and Expressions > Condition >

Column Name

Column Name:
 
|--+------------+--+-column---------------------------------+---|
   +-table--.---+  |  (1)                                   |
   +-view--.----+  '--------row_column--+-----------------+-'
   +-synonym--.-+                       | .-------------. |
   '-alias--.---'                       | V  (2)        | |
                                        '--------.field-+-'

Notes:

Dynamic Server only
Repeat no more than three times

Element	Description	Restrictions	Syntax
alias	Temporary alternative name for table or view	Must be defined in the FROM clause of the SELECT statement	Identifier, p. Identifier
column	Name of a column	Must exist in the specified table	Identifier, p. Identifier
field	A field to compare in a ROW type column	Must be a component of row-column name or field name (for nested rows)	Identifier, p. Identifier
row_column	A column of type ROW	Must be an existing named ROW type or unnamed ROW type	Identifier, p. Identifier
synonym, table, view	Name of a synonym, table, or view	The synonym and the table or view to which it points must exist in the database	Database Object Name, p. Database Object Name

For more information on the meaning of the column name in these conditions, see the IS NULL Condition and the LIKE and MATCHES Condition.