MaxRows (database statements) Purpose Returns or assigns an integer value indicating the ODBC maximum rows to return in a statement. Syntax DBStatement.MaxRows [= NumRows] NumRows Can be set to the desired number of rows or to the constant SQL_MAX_ROWS_DEFAULT, which returns all rows returned from the query.