DatabaseCompatibilityLevel Enumeration
Enumerates the SQL Server database compatibility levels.
Assembly: Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)
| Member name | Description | |
|---|---|---|
| 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).
Show: