Supported functionality in Babelfish by version
In the following table you can find T-SQL functionality supported by different Babelfish versions. For lists of unsupported functionality, see Unsupported functionality in Babelfish. For information about various Babelfish releases, see the Release Notes for Aurora PostgreSQL.
| Functionality or syntax | 2.3.0 | 2.2.0 | 2.1.0 | 1.2.1 | 1.1.0 | 1.0.0 |
|---|---|---|---|---|---|---|
| ALTER ROLE | ✓ | ✓ | ✓ | – | – | – |
| CREATE ROLE | ✓ | ✓ | ✓ | – | – | – |
| Create unique indexes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Cross–database procedure execution | ✓ | ✓ | – | – | – | – |
| Cross–database references SELECT,SELECT..INTO, INSERT, UPDATE, DELETE | ✓ | ✓ | ✓ | – | – | – |
| Cursor-typed parameters for input parameters only (not output) | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Data migration using the bcp client utility | ✓ | ✓ | ✓ | – | – | – |
| Datatypes TIMESTAMP, ROWVERSION (for usage information, see Features with limited implementation | ✓ | ✓ | ✓ | ✓ | – | – |
| DROP DATABASE | ✓ | – | – | – | – | – |
| DROP IF EXISTS (for SCHEMA, DATABASE, and USER objects) | ✓ | ✓ | ✓ | ✓ | – | – |
| DROP ROLE | ✓ | ✓ | ✓ | – | – | – |
| GRANT | ✓ | ✓ | ✓ | ✓ | – | – |
| Identifiers with leading dot character | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| INSTEAD OF triggers on tables (tables only, not views) | ✓ | ✓ | ✓ | ✓ | – | – |
| REVOKE | ✓ | ✓ | ✓ | ✓ | – | – |
| SET BABELFISH_SHOWPLAN_ALL ON (and OFF) | ✓ | ✓ | ✓ | – | – | – |
| SET BABELFISH_STATISTICS PROFILE ON (OFF) | ✓ | ✓ | ✓ | – | – | – |
| SET LOCK_TIMEOUT | ✓ | ✓ | ✓ | ✓ | – | – |
| SSMS: Connecting with the object explorer connection dialog | ✓ | ✓ | ✓ | – | – | – |
| SSMS: Data migration with the Import/Export Wizard | ✓ | ✓ | ✓ | – | – | – |
| SSMS: Partial support for the object explorer | ✓ | ✓ | ✓ | – | – | – |
| Triggers with multiple DML actions can reference transition tables | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| T-SQL hints (join methods, index usage, MAXDOP) | ✓ | – | – | – | – | – |
| Zero-downtime patching (ZDP) | ✓ | – | – | – | – | – |
| Built-in functions: | ||||||
| CHARINDEX | ✓ | ✓ | ✓ | – | – | – |
| CHOOSE | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| COLUMNS_UPDATED | ✓ | ✓ | ✓ | ✓ | – | – |
| COLUMNPROPERTY (CharMaxLen, AllowsNull only) | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| CONCAT_WS | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| CURSOR_STATUS | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| DATEADD | ✓ | – | – | – | – | – |
| DATEDIFF | ✓ | – | – | – | – | – |
| DATEFROMPARTS | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| DATENAME | ✓ | – | – | – | – | – |
| DATEPART | ✓ | – | – | – | – | – |
| DATETIMEFROMPARTS | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| DATETIMEOFFSETFROMPARTS | ✓ | – | – | – | – | – |
| FOR JSON | ✓ | – | – | – | – | – |
| FULLTEXTSERVICEPROPERTY | ✓ | ✓ | ✓ | ✓ | – | – |
| HAS_DBACCESS | ✓ | ✓ | ✓ | ✓ | – | – |
| HAS_PERMS_BY_NAME | ✓ | ✓ | ✓ | – | – | – |
| HOST_NAME | ✓ | ✓ | – | – | – | – |
| IS_MEMBER | ✓ | ✓ | ✓ | – | – | – |
| IS_ROLEMEMBER | ✓ | ✓ | ✓ | – | – | – |
| IS_SRVROLEMEMBER | ✓ | ✓ | ✓ | ✓ | – | – |
| ISJSON | ✓ | ✓ | ✓ | ✓ | – | – |
| JSON_MODIFY | ✓ | – | – | – | – | – |
| JSON_QUERY | ✓ | ✓ | ✓ | ✓ | – | – |
| JSON_VALUE | ✓ | ✓ | ✓ | ✓ | – | – |
| OPENJSON | ✓ | ✓ | ✓ | – | – | – |
| ORIGINAL_LOGIN | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| PATINDEX | ✓ | ✓ | ✓ | – | – | – |
| SCHEMA_NAME | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| SESSION_USER | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| SID_BINARY (returns NULL always) | ✓ | ✓ | – | – | – | – |
| SQUARE | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| STRING_SPLIT | ✓ | ✓ | ✓ | – | – | – |
| SUSER_SID | ✓ | ✓ | ✓ | ✓ | – | – |
| SUSER_SNAME | ✓ | ✓ | ✓ | ✓ | – | – |
| SYSTEM_USER | ✓ | ✓ | – | – | – | – |
| TO_CHAR | ✓ | – | – | – | – | – |
| TRIGGER_NESTLEVEL (without arguments only) | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| TRY_CONVERT | ✓ | – | – | – | – | – |
| UPDATE | ✓ | ✓ | ✓ | ✓ | – | – |
| INFORMATION_SCHEMA catalogs | ||||||
| CHECK_CONSTRAINTS | ✓ | ✓ | – | – | – | – |
| COLUMN_DOMAIN_USAGE | ✓ | ✓ | – | – | – | – |
| COLUMNS | ✓ | ✓ | ✓ | ✓ | – | – |
| CONSTRAINT_COLUMN_USAGE | ✓ | ✓ | ✓ | – | – | – |
| DOMAINS | ✓ | ✓ | ✓ | ✓ | – | – |
| ROUTINES | ✓ | ✓ | – | – | – | – |
| TABLES | ✓ | ✓ | ✓ | ✓ | – | – |
| TABLE_CONSTRAINTS | ✓ | ✓ | ✓ | ✓ | – | – |
| VIEWS | ✓ | ✓ | ✓ | – | – | – |
| System-defined @@ variables: | ||||||
| @@CURSOR_ROWS | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| @@DATEFIRST | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| @@DBTS | ✓ | ✓ | ✓ | ✓ | – | – |
| @@ERROR | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| @@ERROR=213 | ✓ | ✓ | ✓ | – | – | – |
| @@FETCH_STATUS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| @@IDENTITY | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| @@LANGUAGE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| @@LOCK_TIMEOUT | ✓ | ✓ | ✓ | ✓ | – | – |
| @@MAX_CONNECTIONS | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| @@MAX_PRECISION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| @@MICROSOFTVERSION | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| @@NESTLEVEL | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| @@PROCID | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| @@ROWCOUNT | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| @@SERVERNAME | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| @@SERVICENAME | ✓ | ✓ | ✓ | ✓ | – | – |
| @@SPID | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| @@TRANCOUNT | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| @@VERSION (note format difference as described in T-SQL differences in Babelfish. | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| System stored procedures: | ||||||
| sp_addrole | ✓ | – | – | – | – | – |
| sp_addrolemember | ✓ | – | – | – | – | – |
| sp_column_privileges | ✓ | ✓ | ✓ | ✓ | – | – |
| sp_columns | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_columns_100 | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_columns_managed | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_cursor | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_cursor_list | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_cursorclose | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_cursorexecute | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_cursorfetch | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_cursoropen | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_cursoroption | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_cursorprepare | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_cursorprepexec | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_cursorunprepare | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_databases | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_datatype_info | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_datatype_info_100 | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_describe_cursor | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_describe_first_result_set | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_describe_undeclared_parameters | ✓ | ✓ | ✓ | ✓ | – | – |
| sp_droprole | ✓ | – | – | – | – | – |
| sp_droprolemember | ✓ | – | – | – | – | – |
| sp_fkeys | ✓ | ✓ | ✓ | ✓ | – | – |
| sp_getapplock | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sp_helpdb | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sp_helpdbfixedrole | ✓ | – | – | – | – | – |
| sp_helprole | ✓ | ✓ | ✓ | – | – | – |
| sp_helprolemember | ✓ | ✓ | ✓ | – | – | – |
| sp_helpsrvrolemember | ✓ | ✓ | – | – | – | – |
| sp_helpuser | ✓ | ✓ | ✓ | ✓ | – | – |
| sp_oledb_ro_usrname | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_pkeys | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_prefix | ✓ | ✓ | – | – | – | – |
| sp_prepare | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_releaseapplock | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sp_special_columns | ✓ | ✓ | ✓ | ✓ | – | – |
| sp_sproc_columns | ✓ | ✓ | ✓ | – | – | – |
| sp_sproc_columns_100 | ✓ | ✓ | ✓ | – | – | – |
| sp_statistics | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_statistics_100 | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_stored_procedures | ✓ | ✓ | ✓ | ✓ | – | – |
| sp_table_privileges | ✓ | ✓ | ✓ | ✓ | – | – |
| sp_tablecollations_100 | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_tables | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| sp_unprepare | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| xp_qv | ✓ | ✓ | ✓ | ✓ | – | – |
| Properties supported on the CONNECTIONPROPERTY system function | ||||||
| auth_scheme | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| client_net_address | ✓ | ✓ | ✓ | ✓ | – | – |
| local_net_address | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| local_tcp_port | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| net_transport | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| protocol_type | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| physical_net_transport | ✓ | ✓ | ✓ | ✓ | – | – |
| Properties supported on the OBJECTPROPERTY system function | ||||||
| IsInlineFunction | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| IsScalarFunction | ✓ | ✓ | ✓ | ✓ | – | – |
| IsTableFunction | ✓ | ✓ | ✓ | ✓ | ✓ | – |
| Properties supported on the SERVERPROPERTY function | ||||||
| Babelfish | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Collation | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| CollationID | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| Edition | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| EditionID | ✓ | ✓ | ✓ | ✓ | – | – |
| EngineEdition | ✓ | ✓ | ✓ | ✓ | – | – |
| InstanceName | ✓ | ✓ | – | – | – | – |
| IsAdvancedAnalyticsInstalled | ✓ | ✓ | ✓ | ✓ | – | – |
| IsBigDataCluster | ✓ | ✓ | ✓ | ✓ | – | – |
| IsFullTextInstalled | ✓ | ✓ | ✓ | ✓ | – | – |
| IsIntegratedSecurityOnly | ✓ | ✓ | ✓ | ✓ | – | – |
| IsLocalDB | ✓ | ✓ | ✓ | ✓ | – | – |
| IsPolyBaseInstalled | ✓ | ✓ | ✓ | ✓ | – | – |
| IsSingleUser | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| IsXTPSupported | ✓ | ✓ | ✓ | ✓ | – | – |
| Japanese_CI_AI | ✓ | ✓ | ✓ | – | – | – |
| Japanese_CI_AS | ✓ | ✓ | ✓ | – | – | – |
| Japanese_CS_AS | ✓ | ✓ | ✓ | – | – | – |
| LicenseType | ✓ | ✓ | ✓ | ✓ | – | – |
| MachineName | ✓ | ✓ | – | – | – | – |
| ProductMajorVersion | ✓ | ✓ | ✓ | ✓ | – | – |
| ProductMinorVersion | ✓ | ✓ | ✓ | ✓ | – | – |
| ProductVersion | ✓ | ✓ | ✓ | ✓ | – | – |
| ServerName | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| SQL Server views supported by Babelfish | ||||||
| sys.all_columns | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sys.all_objects | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sys.all_parameters | ✓ | – | – | – | – | – |
| sys.all_sql_modules | ✓ | ✓ | ✓ | – | – | – |
| sys.all_views | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sys.columns | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sys.configurations | ✓ | ✓ | ✓ | ✓ | – | – |
| sys.data_spaces | ✓ | ✓ | ✓ | – | – | – |
| sys.database_files | ✓ | ✓ | ✓ | – | – | – |
| sys.database_mirroring | ✓ | ✓ | ✓ | – | – | – |
| sys.database_principals | ✓ | ✓ | ✓ | ✓ | – | – |
| sys.database_role_members | ✓ | ✓ | ✓ | – | – | – |
| sys.databases | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sys.dm_exec_connections | ✓ | ✓ | ✓ | ✓ | – | – |
| sys.dm_exec_sessions | ✓ | ✓ | ✓ | ✓ | – | – |
| sys.dm_hadr_database_replica_states | ✓ | ✓ | ✓ | – | – | – |
| sys.dm_os_host_info | ✓ | ✓ | ✓ | ✓ | – | – |
| sys.endpoints | ✓ | ✓ | ✓ | ✓ | – | – |
| sys.indexes | ✓ | ✓ | ✓ | – | – | – |
| sys.schemas | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sys.server_principals | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sys.sql_modules | ✓ | ✓ | ✓ | – | – | – |
| sys.sysconfigures | ✓ | ✓ | ✓ | ✓ | – | – |
| sys.syscurconfigs | ✓ | ✓ | ✓ | ✓ | – | – |
| sys.sysprocesses | ✓ | ✓ | ✓ | ✓ | – | – |
| sys.table_types | ✓ | ✓ | ✓ | ✓ | – | – |
| sys.tables | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| sys.xml_schema_collections | ✓ | ✓ | ✓ | – | – | – |
| syslanguages | ✓ | ✓ | ✓ | – | – | – |
| sysobjects.crdate | ✓ | – | – | – | – | – |