Indicates that column names returned from a SELECT statement use the default format. In the default format, column names have the form [table-name]_[column-name] when multiple tables are included in the SELECT statement, or [column-name] when the SELECT statement includes a single table.

See also

Indicates that column names returned from a SELECT statement use long-column-name format. In this format, column names use the form [table-name]_[column-name] regardless of how many tables are included in the SELECT statement.

See also

Indicates that column names returned from a SELECT statement use short-column-name format. In this format, column names use the form [column-name], regardless of how many tables are included in the SELECT statement.

If the result set contains multiple columns with the same name, only one property with that name is added to the result object. The value assigned to that property is taken from the last column with that name in the result row. For example, consider the following SELECT statement:

	 SELECT customers.customerId, addresses.customerId

	 FROM customers INNER JOIN addresses

	    ON customers.customerId = addresses.customerId

	 

When this statement is executed on a SQLConnection instance with short column name format, each result object has a property named customerId, containing the value from the addresses table's customerId column.

See also