Returns the name of the column identified by the specified column ID.

Syntax

Visual Basic
Public Function GetColumnSQLName( _
   ByVal columnID As Integer _
) As String

C#
public string  GetColumnSQLName(
   int columnID
);

Parameters

Return value

The name of the column or a null reference (Nothing in Visual Basic) if the column has no name. If the column is aliased in the SQL query, the alias is returned.

Remarks

Note that in result sets, not all columns have names and not all column names are unique. If you are using aliases, the name of the column is the alias.

The GetColumnSQLName method differs from the GetColumnName in that for non-aliased, non-computed columns GetColumnSQLName always returns just the name of the column (without the table name as a prefix). While this behavior more closely resembles the behavior of other ADO.NET providers, it is more likely to produce non-unique names.

Column IDs and count may change during a schema upgrade. To correctly identify a column, access it by name or refresh the cached IDs and counts after a schema upgrade.

See also

• ULCursorSchema class
• ULCursorSchema members
• ColumnCount property
• GetColumnName method
• ColumnCount property