DatabaseCompatibilityLevel Enumeration

 

Enumerates the SQL Server database compatibility levels.

Namespace:   Microsoft.SqlServer.Management.SqlParser.Common
Assembly:  Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)

public enum DatabaseCompatibilityLevel

Member nameDescription
Current

Compatible with the latest version of SQL Server.

Version100

A database compatibility level of 100, or SQL Server 2008.

Version110

A database compatibility level of 110, or SQL Server 2012.

Version120

A database compatibility level of 120, or SQL Server 2014.

Version80

A database compatibility level of 80.

Version90

A database compatibility level of 90, or SQL Server 2005.

A compatibility level sets certain database behaviors to be compatible with the specified version of SQL Server. For more information, see ALTER DATABASE Compatibility Level (Transact-SQL).

Return to top
Show: