Hello everybody:

I want to know if a table is empty or not and I'm using the next query:

SELECT FIRST 1 FIELD1 FROM TABLE1

and then I check if the result is empty or not.

I think this is the best way to do this because the result is only one field of one record (or none if the table is empty) and it should have the best performance.

Is this true? Is there a better way to do this?

Thanks in advance.

Gustavo


[Non-text portions of this message have been removed]