UltraLite.NET User's Guide
  Understanding UltraLite Development
    Accessing and manipulating data with dynamic SQL

Result set schema description

The ResultSet.Schema method allows you to retrieve information about a result set, such as column names, total number of columns, column precisions, column scales, column sizes and column SQL types. The following example shows how you can use ResultSet.Schema to display schema information in a console window.

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