Specifies values that control how a column name is retrieved when describing a result set.
public enum ul_column_name_type
Member name | Description |
---|---|
ul_name_type_sql |
For SELECT statements, returns the alias or correlation name. For tables, returns the column name. |
ul_name_type_sql_column_only |
For SELECT statements, returns the alias or correlation name and exclude any table names that were specified. For tables, returns the column name. |
ul_name_type_base_table |
Returns the underlying table name if it can be determined. If the table does not exist in the database schema, returns an empty string. |
ul_name_type_base_column |
Returns the underlying column name if it can be determined. If the column does not exist in the database schema, returns an empty string. |
ul_name_type_qualified |
Returns the underlying qualified column name, if it can be determined, when used in conjunction with the ULResultSetSchema.GetColumnName method. The returned name can be one of the following values, and is determined in this order:
|
ul_name_type_base |
Indicates that a column name qualified with its table name should be returned when used with the GetColumnName method. If the column name being retrieved is associated with a base table in the query, then the base table name is used as the column qualifier (that is, the base_table_name.column_name value is returned). If the column name being retrieved refers to a column in a correlated table in the query, then the correlation name is used as the column qualifier (that is, the correl_table_name.col_name value is returned). If the column has an alias, then the qualified name of the column being aliased is returned; the alias is not part of the qualified name. Otherwise, an empty string is returned. |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |