General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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!!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only