|
The ResultSet.schema property allows you to retrieve information about the columns in the query.
The following example demonstrates how to use ResultSetSchema to capture schema information.
var i;
var MySchema = rs.schema ;
for ( i = 1; i <= MySchema.columnCount; i++) {
colname = MySchema.getColumnName(i);
coltype = MySchema.getColumnSQLType(colname).toString();
alert ( colname + " " + coltype );
}