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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

On-premise SQL Table Name Suffix

(0) ShareShare
ReportReport
Posted on by 4,007

The SQL Tables of the Business Central Database has long ID as suffix. What is the name for that ID and where can I find more about it? If we write SQL Query in one environment and need to use the same query in another environment, we have to rename the tables in Query since the ID may be different. What is the best way to re-use SQL Query Scripts in such situations?

pastedimage1600560546674v2.png

I have the same question (0)
  • Verified answer
    THE Italian Profile Picture
    Microsoft Employee on at

    All the tenant tables have now an ID that could be the base application ID or system application ID or whatever App ID.

    They should not change in any environment, unless these comes from different app.

  • Community Member Profile Picture
    on at

    Can you please explain more about how the ID's per table are generated?

    We have an application that will support multiple BC customers?  So, how would we know each customer's table suffix Id?

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,965 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,125 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 961 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans