What is compatibility level in SQL Server 2016?

What is SQL Server compatibility level?

Using compatibility level for backward compatibility. The database compatibility level setting provides backward compatibility with earlier versions of SQL Server in what relates to Transact-SQL and query optimization behaviors only for the specified database, not for the entire server.

What is DB compatibility level?

Database compatibility level defines how SQL Server uses certain features. Specifically, it causes them to act like a given version of SQL Server, which is typically done to provide some level of backward compatibility.

Where is SQL Server compatibility level?

Right-click the database, and then select Properties. The Database Properties dialog box opens. In the Select a page pane, select Options. The current compatibility level is displayed in the Compatibility level list box.

How do I change the compatibility level in SQL Server 2016?

In SQL Server Management Studio (SSMS), right-click on the database name, select Properties, select the Options node, click on the drop-down next to Compatibility level and select the level that matches your SQL Server. In my case, it's SQL Server 2016 (130).