Question:

Article:

I need a count of records in a table

Is there a way to get the count of records in a table outside of downloading every record or counting them in the data lake? The planned WO table (MWOPLP) is a problematic table for us and I need to monitor its size fairly closely. On-prem I ran an SQL COUNT(*) or used system tools to get a record count. I can't seem to find a way on Cloud, but I don't really know where to look.
Delivered Read
Group: *MUGA
Comments (2) (Descending Chronological Order)
There are no comments at this time, be the first to comment
BC:
Also, if you do not want to use the Datalake, you can use the EXPORTMI.Select API to do simple SQL queries. It queries directly against the ERP DB. You do not include the SELECT with it though: count(*) from MWOPLP
BC:
I found my answer. AMS050

Online