Result set schema description

The ULDataReader.GetSchemaTable method and ULDataReader.Schema property allow you to retrieve information about a result set, such as column names, total number of columns, column scales, column sizes, and column SQL types.

Example

The following example demonstrates how to use the ULDataReader.Schema and ResultSet.Schema properties to display schema information in a command prompt.

for ( int i = 0; i < MyResultSet.Schema.GetColumnCount(); i++ ) {
      System.Console.WriteLine( MyResultSet.Schema.GetColumnName(i) 
                                + " " 
                                + MyResultSet.Schema.GetColumnSQLType(i) );
}