You can use SELECT COUNT(*) AS RecordCount FROM TableName

As i know there is no SQL Command to return number of field, but you can use FCOUNT(), or if you use Database Engine, you can use SQLCOLUMNS and then use SELECT COUNT(*) AS RecordCount FROM TableName.



>Errr, also is it possible to use SQL command to count the number of *fields* in a table?
>
>Thanks a lot, again :)

>>Hi all,
>>
>>Are there any SQL command to count the number of records in a table?
>>
>>thanks a lot!!