Functionality Supported by Babelfish

4 parts object name references for SELECT statements

Yes

ALTER AUTHORIZATION syntax for changing the database owner

Yes

ALTER DATABASE <db_name> MODIFY NAME = <new_db_name>

Yes

ALTER FUNCTION

No

ALTER PROCEDURE

Yes

ALTER ROLE

Yes

ALTER USER...WITH LOGIN

Yes

AS keyword in CREATE FUNCTION

Yes

AT TIME ZONE clause

Yes

Babelfish instance as a linked server

Yes

Comparison operators !< and !>

Yes

CREATE INDEX ... ON partition_scheme_name (partition_column_name)

Yes

CREATE Instead of Triggers (DML) on SQL Server views

Yes

CREATE PARTITION FUNCTION

Yes

CREATE PARTITION SCHEME

Yes

CREATE ROLE

Yes

CREATE TABLE ... ON partition_scheme_name (partition_column_name)

Yes

CREATE TRIGGER

Yes

Creating unique indexes

Yes

Cross-database procedure execution

Yes

Cross-database references SELECT, INSERT, UPDATE, and DELETE

Yes

Cursor-typed parameters for input parameters only (not output)

Yes

Data migration using the bcp client utility

Yes

Data types TIMESTAMP and ROWVERSION

Yes

DEFAULT keyword in calls to stored procedures and functions

Yes

DBCC CHECKIDENT

Yes

DROP DATABASE

Yes

DROP IF EXISTS (for SCHEMA, DATABASE, and USER objects)

Yes

DROP INDEX index ON schema.table

Yes

DROP INDEX schema.table.index

Yes

DROP PARTITION FUNCTION

Yes

DROP PARTITION SCHEME

Yes

DROP ROLE

Yes

ENABLE/DISABLE TRIGGER

Yes

FULL TEXT SEARCH

Yes

Full-text search using the CONTAINS clause

Yes

Geometry and Geography spatial data types

Yes

GRANT

Yes

GRANT permission [ ,...n ] ON SCHEMA

Yes

GUC babelfishpg_tds.product_version

Yes

Identifiers with leading dot characters

Yes

INSTEAD OF triggers for tables

Yes

INSTEAD OF triggers on views

Yes

KILL

Yes

$PARTITION.partition_function_name(partition_column_value)

Yes

PIVOT

Yes

REVOKE

Yes

REVOKE permission [ ,...n ] ON SCHEMA

Yes

SELECT...OFFSET...FETCH clauses

Yes

SELECT FOR JSON AUTO

Yes

SET BABELFISH_SHOWPLAN_ALL ON (and OFF)

Yes

SET BABELFISH_STATISTICS PROFILE ON (OFF)

Yes

SET CONTEXT_INFO

Yes

SET LOCK_TIMEOUT

Yes

SET NO_BROWSETABLE

Yes

SET rowcount

Yes

SET SHOWPLAN_ALL

Yes

SET STATISTICS IO

Yes

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

Yes

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

Yes

SET TRANSACTION ISOLATION LEVEL syntax

Yes

SSMS: connecting with the Object Explorer connection dialog

Yes

SSMS: data migration with the Import/Export Wizard

Yes

SSMS: partial support for Object Explorer

Yes

STDEV

Yes

STDEVP

Yes

Triggers with multiple DML actions can reference transition tables

Yes

T-SQL hints (join methods, index usage, and MAXDOP)

Yes

T-SQL square bracket syntax with the LIKE predicate

Yes

Unquoted string values in stored procedure calls and default values

Yes

VAR

Yes

VARP

Yes

APP_NAME

Yes

ATN2

Yes

CHARINDEX

Yes

CHOOSE

Yes

COL_LENGTH

Yes

COL_NAME

Yes

COLUMNS_UPDATED

Yes

COLUMNPROPERTY (CharMaxLen, AllowsNull only)

Yes

CONCAT_WS

Yes

CONTEXT_INFO

Yes

CURSOR_STATUS

Yes

DATABASE_PRINCIPAL_ID

Yes

DATEADD

Yes

DATEDIFF

Yes

DATEDIFF_BIG

Yes

DATEFROMPARTS

Yes

DATENAME

Yes

DATEPART

Yes

DATETIMEFROMPARTS

Yes

DATETIME2FROMPARTS

Yes

DATETIMEOFFSETFROMPARTS

Yes

DATETRUNC

Yes

DATE_BUCKET

Yes

EOMONTH

Yes

EXECUTE AS CALLER

Yes

fn_listextendedproperty

Yes

FOR JSON

Yes

FULLTEXTSERVICEPROPERTY

Yes

HAS_DBACCESS

Yes

HAS_PERMS_BY_NAME

Yes

HOST_NAME

Yes

HOST_ID

Yes

IDENTITY

Yes

IS_MEMBER

Yes

IS_ROLEMEMBER

Yes

IS_SRVROLEMEMBER

Yes

ISJSON

Yes

JSON_MODIFY

Yes

JSON_QUERY

Yes

JSON_VALUE

Yes

NEXT VALUE FOR

Yes

OBJECT_DEFINITION

Yes

OBJECT_SCHEMA_NAME

Yes

OPENJSON

Yes

OPENQUERY

Yes

ORIGINAL_LOGIN

Yes

PARSENAME

Yes

PATINDEX

Yes

ROWCOUNT_BIG

Yes

SCHEMA_NAME

Yes

SESSION_CONTEXT

Yes

SESSION_USER

Yes

SID_BINARY (returns NULL always)

Yes

SMALLDATETIMEFROMPARTS

Yes

SQUARE

Yes

STR

Yes

STRING_AGG

Yes

STRING_SPLIT

Yes

SUSER_SID

Yes

SUSER_SNAME

Yes

SWITCHOFFSET

Yes

SYSTEM_USER

Yes

TIMEFROMPARTS

Yes

TODATETIMEOFFSET

Yes

TO_CHAR

Yes

TRIGGER_NESTLEVEL (without arguments only)

Yes

TRY_CONVERT

Yes

TYPE_ID

Yes

TYPE_NAME

Yes

UPDATE

Yes

@@CURSOR_ROWS

Yes

@@DATEFIRST

Yes

@@DBTS

Yes

@@ERROR

Yes

@@ERROR=213

Yes

@@FETCH_STATUS

Yes

@@IDENTITY

Yes

@@LANGUAGE

Yes

@@LOCK_TIMEOUT

Yes

@@MAX_CONNECTIONS

Yes

@@MAX_PRECISION

Yes

@@MICROSOFTVERSION

Yes

@@NESTLEVEL

Yes

@@PROCID

Yes

@@ROWCOUNT

Yes

@@SERVERNAME

Yes

@@SERVICENAME

Yes

@@SPID

Yes

@@TRANCOUNT

Yes

@@VERSION

Yes

sp_addextendedproperty

Yes

sp_addlinkedserver

Yes

sp_addlinkedsrvlogin

Yes

sp_addrole

Yes

sp_addrolemember

Yes

sp_babelfish_volatility

Yes

sp_column_privileges

Yes

sp_columns

Yes

sp_columns_100

Yes

sp_columns_managed

Yes

sp_cursor

Yes

sp_cursor_list

Yes

sp_cursorclose

Yes

sp_cursorexecute

Yes

sp_cursorfetch

Yes

sp_cursoropen

Yes

sp_cursoroption

Yes

sp_cursorprepare

Yes

sp_cursorprepexec

Yes

sp_cursorunprepare

Yes

sp_databases

Yes

sp_datatype_info

Yes

sp_datatype_info_100

Yes

sp_describe_cursor

Yes

sp_describe_first_result_set

Yes

sp_describe_undeclared_parameters

Yes

sp_dropextendedproperty

Yes

sp_droplinkedsrvlogin

Yes

sp_droprole

Yes

sp_droprolemember

Yes

sp_dropserver

Yes

sp_enum_oledb_providers

Yes

sp_execute

Yes

sp_execute_postgresql(CREATE, ALTER, DROP)

Yes

sp_executesql

Yes

sp_fkeys

Yes

sp_getapplock

Yes

sp_helpdb

Yes

sp_helpdbfixedrole

Yes

sp_helplinkedsrvlogin

Yes

sp_helprole

Yes

sp_helprolemember

Yes

sp_helpsrvrolemember

Yes

sp_helpuser

Yes

sp_linkedservers

Yes

sp_oledb_ro_usrname

Yes

sp_pkeys

Yes

sp_prefix

Yes

sp_prepare

Yes

sp_procedure_params_100_managed

Yes

sp_releaseapplock

Yes

sp_rename

Yes

sp_renamedb

Yes

sp_rename (for object_type 'DATABASE')

Yes

sp_reset_connection

No

sp_serverOption (connect_timeout option)

Yes

sp_set_session_context

Yes

sp_special_columns

Yes

sp_sproc_columns

Yes

sp_sproc_columns_100

Yes

sp_statistics

Yes

sp_statistics_100

Yes

sp_stored_procedures

Yes

sp_table_privileges

Yes

sp_tablecollations_100

Yes

sp_tables

Yes

sp_testlinkedserver

Yes

sp_unprepare

Yes

sp_updateextendedproperty

Yes

sp_who

Yes

xp_qv

Yes

information_schema.key_column_usage

Yes

information_schema.routines

Yes

information_schema.schemata

Yes

information_schema.sequences

Yes

sys.all_columns

Yes

sys.all_objects

Yes

sys.all_parameters

Yes

sys.all_sql_modules

Yes

sys.all_views

Yes

sys.columns

Yes

sys.configurations

Yes

sys.data_spaces

Yes

sys.database_files

Yes

sys.database_mirroring

Yes

sys.database_principals

Yes

sys.database_role_members

Yes

sys.databases

Yes

sys.destination_data_spaces

Yes

sys.dm_exec_connections

Yes

sys.dm_exec_sessions

Yes

sys.dm_hadr_database_replica_states

Yes

sys.dm_os_host_info

Yes

sys.dm_os_sys_info

No

sys.endpoints

Yes

sys.extended_properties

Yes

sys.indexes

Yes

sys.partitions

Yes

sys.partition_functions

Yes

sys.partition_parameters

Yes

sys.partition_range_values

Yes

sys.partition_schemes

Yes

sys.schemas

Yes

sys.server_principals

Yes

sys.server_role_members

Yes

sys.sql_modules

Yes

sys.sysconfigures

Yes

sys.syscurconfigs

Yes

sys.syslogins

Yes

sys.sysprocesses

Yes

sys.sysusers

Yes

sys.table_types

Yes

sys.tables

Yes

sys.types

Yes

sys.xml_schema_collections

Yes

syslanguages

Yes

sysobjects.crdate

Yes