SQL table not visible in NAV

ArjanL · 2012-05-25

Hi,

Ik found a table under SQL server in the NAV database, which I cannot find in NAV itself.
It's a custom table, made by someone in the past.

I suspect it was created in SQL (it's filled through a SP).
Is it possible that tables are created through SQL and thus not visible in NAV?
Is there a way to include the table properly into NAV?

kapamarou · 2012-05-25

Yes. You can create a table through sql. You can add it to NAV by dropping it and creating it through NAV or you can create a view on it that acts like a NAV table. The question is what is that table. There should be a reason for it. Since it is filled through a stored procedure this can cause problems in NAV like incorrect characters. It all depends on the usage.

ArjanL · 2012-05-29

Thanks, I think I'll go for the view for now. And create a proper NAV table during the upgrade.
There is some data gathered in it.
Actually I don't see why it isn't done inside NAV.

Howdy, Stranger!

Quick Links

Categories

SQL table not visible in NAV

Answers