Table Information NAV 2013 R2

Juhl

Hi Guys

Where is the Table information button i the Developer Client in 2013R2?

You know the list where you can get the number of records in each table, on the Database Information window.
(File -> Database -> Information -> Tables)


Can we get i back?

ara3n

It's gone because of tenant functionality.

Juhl

I thought it had something to do with that. Thanks.

I tried creating a page for this virtuel tabel, as it still exist. But it throws a Sql error.

Is it possible to get this info?
I need record counts from each table.

I could do this in sql.

ara3n

You can create a new list page and add code to get the count for each record at run time.
or you can do it from sql.

In SQL SMS right click on database->reports->std reports->Disk usage by Table.

It will give you the report.

Skipie

Report 104001 in UpgradeToolKit17 does provide this function.
SQL report works too, but there are multiple instances of some of the tables and names are formatted differently.