how do i check whether the table in my database have any information or not?????
Printable View
how do i check whether the table in my database have any information or not?????
What's a schemaAdapter or a schemaTable? I've never heard of of either. Regardless, from the names they deal with schema, which has nothing to do with data. If you want to know whether or not a table contains data the most likely way would be to execute a query to get the record count:You can then compare the result to zero to see whether there are any records.Code:SELECT COUNT(*) FROM MyTable