Specifies the maximum number of rows the provider returns when a query does not include aggregation or grouping.

Data Type

string

Default Value

"-1"

Remarks

This property controls the number of rows the server returns when running a query without aggregation or GROUP BY clauses.

Set this property to a positive integer to limit the number of rows returned. Set it to -1 to return all available rows.

Limiting rows can improve performance when previewing data in design-time environments such as business intelligence tools or query builders.

Use this property when working with large datasets and you want to avoid loading the entire result set during development or metadata exploration.