Melvin Davidson wrote:
OK, one more time.
Yes I know that right click count does that!
I know about select count(*).
I know about Right-click -> Count
The question was/is "What is the equivalent SQL function to update the
Rows(counted) value?
Right, one more time :-)
There is no SQL functio
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 v
Melvin Davidson wrote:
Right clicking on a table show the "count" option, which updates the
Rows(counted) value in the properties window for the table.
Is there an equivalent SQL command? ANALYZE/ table_name/ does not work
as the equivalent.
SELECT count(*) FROM table;
Regards Dave
--
