Melvin Davidson wrote:
> Dave,
>
> Yes SELECT count(*) FROM table; will give me a count of rows
> but it does _not_ update the "Rows(counted) value in the properties
> window"
>
> So what is the equivalent function to update the "Rows(counted) value in
> the properties window"???
Right-click -> Count. The value shown is retrieved on the fly using
SELECT count(*), but only if the estimated value is lower than the
threshold set under Tools->Options (unless you explicitly select Count
from the menu).
Regards, Dave