web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Freebie View Script To...
Small and medium business | Business Central, N...
Suggested Answer

Freebie View Script To Rename BC Tables and Columns

(1) ShareShare
ReportReport
Posted on by Peter Jones - BIDA 151
Hi All,
Not a question but just letting BC people know.
We have released a /freebie/ for Business Central installed accounts if you would like it.
This is a script to create views that rename of all the tables and columns in 2023 wave 2.
The views simply make it easier to write /direct query/ sql against the underlying tables for on premise installs.
It will help companies that have direct query against the underlying Business Central database to save time and money.
The use of this script would typically be for BI/Reporting on BC, so I thought this was a good place to announce this for the BC community.
If anyone wants to pass these links around that would be much appreciated. 
This is a genuine freebie. We are not asking for anyones email address to download the create views file. 
You are all welcome. :-) 
 
You can download the script directly from this link.
https://bida.ro/wp-content/uploads/2024/02/99-Business-Central-Table-Column-Aliases-01.zip
 
You can read (or listen to) the blog post describing it on this link.
https://bida.ro/2024/02/24/bida0042-business-central-tables-and-columns-rename-script/
 
If anyone wants the same for Navision? Please let us know.
We have decided to not go ahead with our planned Navision 2018 products in favour of just jumping to the current Business Central release.
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,798 Super User 2025 Season 2 on at
    Thanks, Will look into it. Would be great if You could also post some screenshots of the end result
  • Peter Jones - BIDA Profile Picture
    Peter Jones - BIDA 151 on at
    Hi YUN ZHU ,
     
    I went over to community blogs and it does not appear that I can create a blog entry.
     
    There is only a button for "Post a question" rather like here for me.
     
    Perhaps as a newbie I am not "qualified" to post blogs yet.
     
    But that is a great source of blog entries and I will look through them for the area of BI etc.
     
    Thank you for the pointer!
     
    Best Regards 
     
    Peter
  • Peter Jones - BIDA Profile Picture
    Peter Jones - BIDA 151 on at
    Hi Judy ,
     
    Thanks for your comment.
     
    We are new to the BC area as we have been working on Nav for years.
     
    On Nav we created staging areas and people could query the staging areas with the new names.
     
    We also did Nav data warehouses.
     
    Now we are going to do BC data warehouses but we don't have a signed up customer at the moment.
     
    We are presuming that there are plenty of people with BC on premise who want to do direct query against the underlying tables.
     
    I mean, direct query on the underlying tables is that much harder in BC, why wouldn't people want to make that a little easier?
     
    Once we get some production BC hands on experience I guess we will see what people are actually doing.

    We will also browse through these forums because questions people ask show what they are doing.
     
    Best Regards 
     
    Peter
  • Peter Jones - BIDA Profile Picture
    Peter Jones - BIDA 151 on at
     Hi YUN ZHU ,
     
    thank you for the tip.
     
    We are new to these forums and we don't want to "over step the bounds" of talking about what we will be selling in the future.
     
    We have been doing BI on Navision for a long time and we will be bringing out a BC product.
     
    So we will give away some really useful freebies and those who use them we will let them know what else we have.
     
    Then people can just politely say they are not interested in what else we have. :-) 
     
    Best Regards 
     
    Peter
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Thank you for sharing this. It will help others on the community who have the same requirements.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 96,266 Super User 2025 Season 2 on at
    Hi, I suggest you share this information to the Community blog, as I personally think it would be more effective.
     
     
    Thanks.
    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,457

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 742 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 669 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans