The backend version is not supported to design database diagrams or tables
This is commonly reported as an error due to using the wrong version of SSMS(Sql Server Management Studio). Use the version designed for your database version. You can use the command select @@version
to check which version of sql server you are actually using. This version is reported in a way that is easier to interpret than that shown in the Help About in SSMS.
Using a newer version of SSMS than your database is generally error-free, i.e. backward compatible.
Microsoft SQL Server Management Studio (2012)
The error is literally telling you the problem here, the version of SSMS you are using (SSMS 2012) does not support the back end version that you are using (SQL Server 2019). I can tell it's 2019 because in the top left of that image it has Version 15......
The first version of SSMS to provide support for SQL Server 2019 was SSMS 18.0, which was release on 2019-04-19.
What's new in 18.0
New item Details Support for SQL Server 2019 SSMS 18.0 is the first release that is fully aware of SQL Server 2019 (compatLevel 150). Support for SQL Server 2019 Support for "BATCH_STARTED_GROUP" and "BATCH_COMPLETED_GROUP" in SQL Server 2019 and SQL Managed Instance. Support for SQL Server 2019 SMO: Added support for UDF Inlining. Support for SQL Server 2019 GraphDB: Add a flag in showplan for Graph TC Sequence. Support for SQL Server 2019 Always Encrypted: added support for AEv2 / Enclave. Support for SQL Server 2019 Always Encrypted: connection dialog has a new tab "Always Encrypted" when the user clicks on the "Options" button to enable/configure Enclave support.
Database Design and relation diagrams details
I think your solution is to use a database diagram (https://msdn.microsoft.com/en-us/library/ms189078.aspx)
Just drag all tables on the screen and it will show you the relations, this of course only when the primary-keys/foreign-keys are there.
For the error you are getting:
if I google that for you I get:
The backend version is not supported to design database diagrams or tablesThe answer marked as the solution is:
This is commonly reported as an error due to using the wrong version
of SMSS. Use the version designed for your database version. You can
use select @@version to check which version of sql server you are
actually using
Related Topics
Search for "Whole Word Match" with SQL Server Like Pattern
How to Export Image Field to File
How to Get a SQL Row_Number Equivalent for a Spark Rdd
SQL Server 2008 Paging Methods
Sqlite Select with Condition on Date
How Exactly Does Using or in a MySQL Statement Differ With/Without Parentheses
Custom Function with Check Constraint SQL Server 2008
SQL Speed Up Performance of Insert
Sql, How to Concatenate Results
Why Is My T-SQL Left Join Not Working
Use Select Inside an Update Query
Error: Functions in Index Expression Must Be Marked Immutable in Postgres
How to Do an Inner Join on Row Number in SQL Server
How to Compare Two SQLite Databases on Linux
Rodbc Temporary Table Issue When Connecting to Ms SQL Server
How to Turn on Regexp in SQLite3 and Rails 3.1