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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings