Compatibility level in SQL Server is a property that determines how the database behaves in terms of syntax and query optimization, allowing for backward compatibility with older versions. Methods to identify and change the compatibility level include using dynamic management views and SQL Server Management Studio, as well as executing the ALTER DATABASE command. New features introduced with different compatibility levels include Query Store, Intelligent Query Processing, and Temporal Tables, among others.
Table of contents
List of compatibility levels in SQL Server and features introduced in each compatibility level.Database compatibility level 120Database compatibility level 130Database compatibility level 150Important NotesView compatibility of SQL Database.Change compatibility level using ALTER DATABASE statement.Change compatibility level using SQL Server Management StudioSummarySee moreSort: