0

Is it possible to tell where a given field is being used in a database?

I know this is a long-shot but I figured it’s at least worth asking…

I have a number of fields I’d like to delete from some of my tables. I’m almost certain I’m not using the fields anywhere but it’s the “almost certain” part that concerns me. Is there any way to determine where any given field is being used in the database before I go and delete it?

Thanks in advance.

4 replies

null
    • Agus
    • 4 yrs ago
    • Reported - view

    I know that they where working on something that shows where fields are being used in code. But we never get any updates from the team to know if and when are getting anything new for ninox :/

    • maroon_banana
    • 4 yrs ago
    • Reported - view

    Hello :), 

    When I'm not sure about something I do a restore on the database. Basically it will duplicate your database. Then I give a go on the duplicate database and if it works I update my 'real' databse.

    Hope it helps :)

    • BlairW
    • 4 yrs ago
    • Reported - view

    Can anyone confirm whether or not Ninox is working on something that will show where fields are being used in a database? Not having this ability has become a real problem for me given the number of fields I have. I know many of them never got used but for the life of me I can't figure out how to tell which ones are being used and which ones aren't.

    • Sean
    • 4 yrs ago
    • Reported - view

    You can do this with the count() function and select command in a formula field...

     

    count(select YourTable where YourField != null)

     

    If the result is 0 then you can make your decision about that field.

Login to reply

Content aside

  • 4 yrs agoLast active
  • 4Replies
  • 1194Views