Shulou(Shulou.com)05/31 Report--

This article is to share with you about how to count the rows of HANA database tables. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article.

In ABAP, if we want to use code to get how many records there are in a database table, the general practice is to use SELECT COUNT.

If you are using a HANA database, there is a new way to achieve the same goal. There is a system view called m_tables in the HANA database, which stores the metadata of the database tables.

I wrote a tool that can query m_tables to get the number of records and storage space occupied by a series of database tables in batches.

The above is how to count the rows of HANA database tables. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.