Determine if table keys are being used/still required

ytoffey

Does anyone know of any free utility that can be used to determine if keys are still required ?

bostjanl

ytoffey wrote:

Does anyone know of any free utility that can be used to determine if keys are still required ?

MBS Navision Developer Toolkit is free for NSC. With "Where used" functionality you can chech if key is used or not,..


Bostjan

eromein

Yes, you can probably create a report that print key's that aren't used based on NDTK tables.

But I could be mistaken...

janpieter

I was planning on making one, but so far no time ...

ytoffey

Thanx for the resopnses guys.

I'm not that familiar NDTK, but this isn't exactly what I'm looking for i.e. I have to manually use the 'Where Used' function on one key at a time. Also, if I stand on "Item No.,Variant Code,Drop Shipment,Location Code,Bin Code,Posting Date" key of the ILE table (32), then it would include in the results "ItemLedgEntry.SETCURRENTKEY("Item No.");"

As for writing a report using the NDTK tables, can I have a little more detail. What NDTK tables?

eromein

dude,

You'll have to download the "Navision Developers Toolkit (NDTK)". You can do some from the download section of mibuso.com.

Then (RTFM ) read the manual. You'll see that the NDTK is the tool you are looking for.

Mind you!!!! The change is, deleting keys will almost always lead to problems.

spycraft

since we are on the topic of keys, Navision offers the flexibilty of enabling / disabling keys in table designer. Can someone advise that if a key is disabled, means that data will not be kept for the disabled key?

The objective i want to achieve is to minimise the growth of the database by disabling unused keys.