Supported functionalities in Babelfish by version
In the following tables, you can find the list of all the functionalities supported by different Babelfish versions. For lists of unsupported functionality, see Unsupported functionalities in Babelfish. For information about various Babelfish releases, see the Release Notes for Aurora PostgreSQL.
Aurora and PostgreSQL features
In the following table, you can find Aurora and PostgreSQL features supported by different Babelfish versions.
Aurora and PostgreSQL features | 4.3.0 | 4.2.0 | 4.1.0 | 4.0.0 | 3.7.0 | 3.6.0 | 3.5.0 | 3.4.0 | 3.3.0 | 3.2.0 | 3.1.0 | 2.10.0 | 2.9.0 | 2.8.0 | 2.7.0 | 2.6.0 | 2.5.0 | 2.4.0 | 2.3.0 | 2.2.0 | 2.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Aurora ML services | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
Database authentication with Kerberos using AWS Directory Service | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
Dump and restore | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
pg_stat_statement extension | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
pgvector | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
Zero-downtime patching (ZDP) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
T-SQL Functionality or syntax
In the following table, you can find T-SQL functionality or syntax supported by different Babelfish versions.
T-SQL Functionality or syntax | 4.3.0 | 4.2.0 | 4.1.0 | 4.0.0 | 3.7.0 | 3.6.0 | 3.5.0 | 3.4.0 | 3.3.0 | 3.2.0 | 3.1.0 | 2.10.0 | 2.9.0 | 2.8.0 | 2.7.0 | 2.6.0 | 2.5.0 | 2.4.0 | 2.3.0 | 2.2.0 | 2.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 parts object name references for SELECT statements | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
ALTER AUTHORIZATION syntax to change database owner | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
ALTER DATABASE <db_name> MODIFY NAME = <new_db_name> |
Yes | Yes | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
ALTER ROLE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ALTER USER...WITH LOGIN | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
AS keyword in CREATE FUNCTION | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
AT TIME ZONE clause | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
Babelfish instance as a linked server | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
Comparison operators !< and !> | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
CREATE INDEX ... ON partition_scheme_name (partition_column_name) | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
CREATE Instead of Triggers (DML) on SQL Server Views | Yes | Yes | No | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
CREATE PARTITION FUNCTION | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
CREATE PARTITION SCHEME | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
CREATE ROLE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
CREATE TABLE ... ON partition_scheme_name (partition_column_name) | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
CREATE TRIGGER | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Create unique indexes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Cross–database procedure execution | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Cross–database references SELECT, INSERT, UPDATE, DELETE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Cursor-typed parameters for input parameters only (not output) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Data migration using the bcp client utility | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Datatypes TIMESTAMP, ROWVERSION (for usage information, see Features with limited implementation | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
DEFAULT keyword in calls to stored procedures and functions | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
DBCC CHECKIDENT | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
DROP DATABASE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
DROP IF EXISTS (for SCHEMA, DATABASE, and USER objects) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
DROP INDEX index ON schema.table | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
DROP INDEX schema.table.index | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
DROP PARTITION FUNCTION | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
DROP PARTITION SCHEME | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
DROP ROLE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ENABLE/DISABLE TRIGGER | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
FULL TEXT SEARCH | Yes | Yes | Yes | Yes |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
Full Text Search with CONTAINS clause | Yes | Yes | Yes | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
Geometry and Geography spatial datatypes | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
GRANT | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
GRANT permission [ ,...n ] ON SCHEMA | Yes | Yes | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
GUC babelfishpg_tds.product_version | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
Identifiers with leading dot character | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
INSTEAD OF triggers on tables | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
INSTEAD OF triggers on views | Yes | Yes | Yes | Yes |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
KILL | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
$PARTITION.partition_function_name(partition_column_value) | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
PIVOT(supported from 3.4.0 and higher releases except when used in a view definition, a common table expression, or a join) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
REVOKE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
REVOKE permission [ ,...n ] ON SCHEMA | Yes | Yes | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
SELECT...OFFSET...FETCH clauses | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
SELECT FOR JSON AUTO | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
SET BABELFISH_SHOWPLAN_ALL ON (and OFF) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SET BABELFISH_STATISTICS PROFILE ON (OFF) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SET CONTEXT_INFO | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
SET LOCK_TIMEOUT | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SET NO_BROWSETABLE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
SET rowcount | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
SET SHOWPLAN_ALL | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
SET STATISTICS IO | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
SET TRANSACTION ISOLATION LEVEL syntax | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
SSMS: Connecting with the object explorer connection dialog | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SSMS: Data migration with the Import/Export Wizard | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SSMS: Partial support for the object explorer | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
STDEV | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
STDEVP | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
Triggers with multiple DML actions can reference transition tables | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
T-SQL hints (join methods, index usage, MAXDOP) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
T-SQL square bracket syntax with the LIKE predicate | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
Unquoted string values in stored procedure calls and default values | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
VAR | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
VARP | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
T-SQL Built-in functions
In the following table, you can find T-SQL Built-in functions supported by different Babelfish versions.
T-SQL Built-in functions | 4.3.0 | 4.2.0 | 4.1.0 | 4.0.0 | 3.7.0 | 3.6.0 | 3.5.0 | 3.4.0 | 3.3.0 | 3.2.0 | 3.1.0 | 2.10.0 | 2.9.0 | 2.8.0 | 2.7.0 | 2.6.0 | 2.5.0 | 2.4.0 | 2.3.0 | 2.2.0 | 2.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
APP_NAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
ATN2 | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
CHARINDEX | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
CHOOSE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
COL_LENGTH | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
COL_NAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
COLUMNS_UPDATED | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
COLUMNPROPERTY (CharMaxLen, AllowsNull only) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
CONCAT_WS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
CONTEXT_INFO | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
CURSOR_STATUS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
DATABASE_PRINCIPAL_ID | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
DATEADD | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
DATEDIFF | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
DATEDIFF_BIG | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
DATEFROMPARTS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
DATENAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
DATEPART | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
DATETIMEFROMPARTS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
DATETIME2FROMPARTS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
DATETIMEOFFSETFROMPARTS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
DATETRUNC | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
Yes | Yes | Yes | No | No | No | No | No | No | No |
DATE_BUCKET | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
Yes | Yes | Yes | No | No | No | No | No | No | No |
EOMONTH | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
Yes | Yes | Yes | No | No | No | No | No | No | No |
EXECUTE AS CALLER | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
fn_listextendedproperty | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
FOR JSON | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
FULLTEXTSERVICEPROPERTY | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
HAS_DBACCESS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
HAS_PERMS_BY_NAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
HOST_NAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
HOST_ID | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
IDENTITY | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
IS_MEMBER | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IS_ROLEMEMBER | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IS_SRVROLEMEMBER | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ISJSON | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
JSON_MODIFY | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
JSON_QUERY | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
JSON_VALUE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
NEXT VALUE FOR | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
OBJECT_DEFINITION | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
OBJECT_SCHEMA_NAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
OPENJSON | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
OPENQUERY | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ORIGINAL_LOGIN | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
PARSENAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
PATINDEX | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ROWCOUNT_BIG | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
SCHEMA_NAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SESSION_CONTEXT | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
SESSION_USER | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SID_BINARY (returns NULL always) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
SMALLDATETIMEFROMPARTS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | Yes | No | No | No | No | No |
SQUARE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
STR | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
STRING_AGG | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
Yes | No | No | No | No | No | No | No | No | No |
STRING_SPLIT | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SUSER_SID | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SUSER_SNAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SWITCHOFFSET | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
SYSTEM_USER | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
TIMEFROMPARTS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
TODATETIMEOFFSET | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
TO_CHAR | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
TRIGGER_NESTLEVEL (without arguments only) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
TRY_CONVERT | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
TYPE_ID | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
TYPE_NAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
UPDATE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
T-SQL INFORMATION_SCHEMA catalogs
In the following table, you can find T-SQL INFORMATION_SCHEMA catalogs supported by different Babelfish versions.
T-SQL INFORMATION_SCHEMA catalogs | 4.3.0 | 4.2.0 | 4.1.0 | 4.0.0 | 3.7.0 | 3.6.0 | 3.5.0 | 3.4.0 | 3.3.0 | 3.2.0 | 3.1.0 | 2.10.0 | 2.9.0 | 2.8.0 | 2.7.0 | 2.6.0 | 2.5.0 | 2.4.0 | 2.3.0 | 2.2.0 | 2.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CHECK_CONSTRAINTS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
COLUMN_DOMAIN_USAGE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
COLUMNS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
CONSTRAINT_COLUMN_USAGE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
DOMAINS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
KEY_COLUMN_USAGE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
ROUTINES | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
TABLES | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
TABLE_CONSTRAINTS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
VIEWS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
T-SQL System-defined @@ variables
In the following table, you can find T-SQL System-defined @@ variables supported by different Babelfish versions.
T-SQL System-defined @@ variables | 4.3.0 | 4.2.0 | 4.1.0 | 4.0.0 | 3.7.0 | 3.6.0 | 3.5.0 | 3.4.0 | 3.3.0 | 3.2.0 | 3.1.0 | 2.10.0 | 2.9.0 | 2.8.0 | 2.7.0 | 2.6.0 | 2.5.0 | 2.4.0 | 2.3.0 | 2.2.0 | 2.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
@@CURSOR_ROWS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@DATEFIRST | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@DBTS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@ERROR | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@ERROR=213 | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@FETCH_STATUS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@IDENTITY | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@LANGUAGE | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@LOCK_TIMEOUT | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@MAX_CONNECTIONS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@MAX_PRECISION | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@MICROSOFTVERSION | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@NESTLEVEL | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@PROCID | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@ROWCOUNT | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@SERVERNAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@SERVICENAME | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@SPID | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@TRANCOUNT | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
@@VERSION (note format difference as described in T-SQL differences in Babelfish. | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
T-SQL System stored procedures
In the following table, you can find T-SQL System stored procedures supported by different Babelfish versions.
T-SQL System stored procedures | 4.3.0 | 4.2.0 | 4.1.0 | 4.0.0 | 3.7.0 | 3.6.0 | 3.5.0 | 3.4.0 | 3.3.0 | 3.2.0 | 3.1.0 | 2.10.0 | 2.9.0 | 2.8.0 | 2.7.0 | 2.6.0 | 2.5.0 | 2.4.0 | 2.3.0 | 2.2.0 | 2.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_addextendedproperty | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
sp_addlinkedserver | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
sp_addlinkedsrvlogin | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
sp_addrole | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
sp_addrolemember | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
sp_babelfish_volatility | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
sp_column_privileges | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_columns | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_columns_100 | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_columns_managed | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_cursor | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_cursor_list | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_cursorclose | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_cursorexecute | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_cursorfetch | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_cursoropen | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_cursoroption | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_cursorprepare | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_cursorprepexec | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_cursorunprepare | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_databases | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_datatype_info | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_datatype_info_100 | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_describe_cursor | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_describe_first_result_set | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_describe_undeclared_parameters | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_dropextendedproperty | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
sp_droplinkedsrvlogin | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
sp_droprole | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
sp_droprolemember | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
sp_dropserver | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
sp_enum_oledb_providers | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
sp_execute | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_execute_postgresql(CREATE, ALTER, DROP) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
sp_executesql | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_fkeys | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_getapplock | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_helpdb | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_helpdbfixedrole | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
sp_helplinkedsrvlogin | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
sp_helprole | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_helprolemember | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_helpsrvrolemember | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
sp_helpuser | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_linkedservers | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
sp_oledb_ro_usrname | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_pkeys | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_prefix | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
sp_prepare | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_procedure_params_100_managed | Yes | Yes | Yes | No |
Yes | Yes | Yes | No | No | No | No |
No | No | No | No | No | No | No | No | No |
|
sp_releaseapplock | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_rename | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
sp_renamedb | Yes | Yes | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
sp_rename (for object_type 'DATABASE') | Yes | Yes | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
sp_serveroption(connect_timeout option) | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
sp_set_session_context | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
sp_special_columns | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_sproc_columns | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_sproc_columns_100 | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_statistics | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_statistics_100 | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_stored_procedures | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_table_privileges | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_tablecollations_100 | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_tables | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_testlinkedserver | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
sp_unprepare | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sp_updateextendedproperty | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
sp_who | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
xp_qv | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
T-SQL Properties supported on the CONNECTIONPROPERTY system function
In the following table, you can find T-SQL Properties supported on the CONNECTIONPROPERTY system functions supported by different Babelfish versions.
T-SQL Properties supported on the CONNECTIONPROPERTY system function | 4.3.0 | 4.2.0 | 4.1.0 | 4.0.0 | 3.7.0 | 3.6.0 | 3.5.0 | 3.4.0 | 3.3.0 | 3.2.0 | 3.1.0 | 2.10.0 | 2.9.0 | 2.8.0 | 2.7.0 | 2.6.0 | 2.5.0 | 2.4.0 | 2.3.0 | 2.2.0 | 2.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
auth_scheme | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
client_net_address | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
local_net_address | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
local_tcp_port | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
net_transport | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
protocol_type | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
physical_net_transport | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
T-SQL Properties supported on the OBJECTPROPERTY system function
In the following table, you can find T-SQL Properties supported on the OBJECTPROPERTY system functions supported by different Babelfish versions.
T-SQL Properties supported on the OBJECTPROPERTY system function | 4.3.0 | 4.2.0 | 4.1.0 | 4.0.0 | 3.7.0 | 3.6.0 | 3.5.0 | 3.4.0 | 3.3.0 | 3.2.0 | 3.1.0 | 2.10.0 | 2.9.0 | 2.8.0 | 2.7.0 | 2.6.0 | 2.5.0 | 2.4.0 | 2.3.0 | 2.2.0 | 2.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
IsInlineFunction | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IsScalarFunction | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IsTableFunction | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
T-SQL Properties supported on the SERVERPROPERTY function
In the following table, you can find T-SQL Properties supported on the SERVERPROPERTY functions supported by different Babelfish versions.
T-SQL Properties supported on the SERVERPROPERTY function | 4.3.0 | 4.2.0 | 4.1.0 | 4.0.0 | 3.7.0 | 3.6.0 | 3.5.0 | 3.4.0 | 3.3.0 | 3.2.0 | 3.1.0 | 2.10.0 | 2.9.0 | 2.8.0 | 2.7.0 | 2.6.0 | 2.5.0 | 2.4.0 | 2.3.0 | 2.2.0 | 2.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Babelfish | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Collation | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
CollationID | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Edition | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
EditionID | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
EngineEdition | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
InstanceName | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
IsAdvancedAnalyticsInstalled | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IsBigDataCluster | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IsFullTextInstalled | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IsIntegratedSecurityOnly | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IsLocalDB | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IsPolyBaseInstalled | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IsSingleUser | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IsXTPSupported | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Japanese_CI_AI | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Japanese_CI_AS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Japanese_CS_AS | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
LicenseType | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
MachineName | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
ProductLevel | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
ProductMajorVersion | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ProductMinorVersion | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ProductUpdateLevel | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
ProductVersion | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
ServerName | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SQL Server views supported by Babelfish
In the following table, you can find SQL Server views supported by different Babelfish versions.
SQL Server views supported by Babelfish | 4.3.0 | 4.2.0 | 4.1.0 | 4.0.0 | 3.7.0 | 3.6.0 | 3.5.0 | 3.4.0 | 3.3.0 | 3.2.0 | 3.1.0 | 2.10.0 | 2.9.0 | 2.8.0 | 2.7.0 | 2.6.0 | 2.5.0 | 2.4.0 | 2.3.0 | 2.2.0 | 2.1.0 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
information_schema.key_column_usage | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
Yes | Yes | Yes | No | No | No | No | No | No | No |
information_schema.routines | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
information_schema.schemata | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
information_schema.sequences | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
sys.all_columns | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.all_objects | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.all_parameters | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |
sys.all_sql_modules | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.all_views | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.columns | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.configurations | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.data_spaces | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.database_files | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.database_mirroring | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.database_principals | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.database_role_members | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.databases | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.destination_data_spaces | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
sys.dm_exec_connections | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.dm_exec_sessions | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.dm_hadr_database_replica_states | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.dm_os_host_info | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.endpoints | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.extended_properties | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | No | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
sys.indexes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.partitions | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
sys.partition_functions | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
sys.partition_parameters | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
sys.partition_range_values | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
sys.partition_schemes | Yes | No | No | No |
No | No | No | No | No | No | No |
No | No | No | No | No | No | No | No | No | No |
sys.schemas | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.server_principals | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.server_role_members | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | No | No | No |
No | No | No | No | No | No | No | No | No | No |
sys.sql_modules | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.sysconfigures | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.syscurconfigs | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.syslogins | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
sys.sysprocesses | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.sysusers | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | No |
Yes | Yes | Yes | Yes | No | No | No | No | No | No |
sys.table_types | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.tables | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sys.types | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
sys.xml_schema_collections | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
syslanguages | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
sysobjects.crdate | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No |