>Is there a way to read the number of rows (records) in a table in an SQl 7 database without having to d a select * and wait until the cursor loads???
>
>I have a moderate size table and it take 5 minutes to load as a remoe view in Foxpro and all I need to know is how many rows (records) are in the table.
>
>THANKS
>Joel
>Houston, TX

select rows from sysindexes where id=object_id(lcTableName) and indid<2

Cetin