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)
Syntax
'Declaration
Public Enumeration DatabaseCompatibilityLevel
'Usage
Dim instance As DatabaseCompatibilityLevel
public enum DatabaseCompatibilityLevel
public enum class DatabaseCompatibilityLevel
type DatabaseCompatibilityLevel
public enum DatabaseCompatibilityLevel
Members
| Member name | Description | |
|---|---|---|
| Current | Compatible with the latest version of SQL Server. | |
| Version80 | A database compatibility level of 80, or SQL Server 2000. | |
| Version90 | A database compatibility level of 90, or SQL Server 2005. | |
| Version100 | A database compatibility level of 100, or SQL Server 2008. |
Remarks
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).