SET ROWCOUNT

From Lianjapedia
Jump to: navigation, search

Purpose

Determines whether or not tables are scanned to obtain a rowcount of non-deleted records that match the current filter

Syntax

SET ROWCOUNT ON | OFF | (<expL>)

See Also

RECCOUNT(), ROWCOUNT()

Description

If SET ROWCOUNT is ON (default), tables are scanned to obtain a rowcount of non-deleted records that match the current filter. If SET ROWCOUNT is OFF, this scan is disabled.

Example

set rowcount off