Hi,

I am using InterBase 6.0.2.

How can I check if a table is empty?

I have a table named MyTable with a field named XXX.

I have been using the instruction below to check if MyTable is empty
or not:


"Select Count(XXX) as NumRecords from MyTable"


If NumRecords = 0 then MyTable is empty.


Is there another way to do check if a table is empty?

Thanks for any help.

Best regards,

Marcelo C. Rosman