SQL on FHIR
2.1.0-pre - ci-build International flag

SQL on FHIR, published by HL7 International / FHIR Infrastructure. This guide is not an authorized publication; it is the continuous build for version 2.1.0-pre built by the FHIR (HL7® FHIR® Standard) CI Build. This version is based on the current content of https://github.com/HL7/sql-on-fhir/ and changes regularly. See the Directory of published versions

ValueSet: All SQL Content Type Codes

Official URL: http://hl7.org/fhir/uv/sql-on-fhir/ValueSet/AllSQLContentTypeCodes Version: 2.1.0-pre
Standards status: Draft Computable Name: AllSQLContentTypeCodes
Other Identifiers: OID:2.16.840.1.113883.4.642.40.77.48.1

ValueSet of all codes from SQL Content Type Codes codesystem

References

This value set is not used here; it may be used elsewhere (e.g. specifications and/or implementations that use this content)

Logical Definition (CLD)

 

Expansion

Expansion performed internally based on codesystem SQL Content Type Codes v2.1.0-pre (CodeSystem)

This value set contains 23 concepts

SystemCodeDisplay (en)DefinitionJSONXML
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sqlSQLStandard SQL content (no dialect specified)
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=ansi-sqlANSI SQLSQL content using ANSI SQL dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=bigqueryBigQuerySQL content using Google BigQuery dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=clickhouseClickHouseSQL content using ClickHouse dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=db2IBM DB2SQL content using IBM DB2 dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=duckdbDuckDBSQL content using DuckDB dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=h2H2SQL content using H2 dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=hiveHiveSQL content using Apache Hive dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=hsqldbHSQLDBSQL content using HyperSQL dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=mariadbMariaDBSQL content using MariaDB dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=mysqlMySQLSQL content using MySQL dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=oracleOracle SQLSQL content using Oracle dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=postgresqlPostgreSQLSQL content using PostgreSQL dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=prestoPrestoSQL content using Presto dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=redshiftAmazon RedshiftSQL content using Amazon Redshift dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=snowflakeSnowflakeSQL content using Snowflake dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=spark-sqlSpark SQLSQL content using Apache Spark SQL dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=sql-2SQL-2SQL content using SQL-2 dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=sql-serverSQL ServerSQL content using Microsoft SQL Server dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=sqliteSQLiteSQL content using SQLite dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=teradataTeradataSQL content using Teradata dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=trinoTrinoSQL content using Trino dialect
http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/SQLContentTypeCodes  application/sql;dialect=verticaVerticaSQL content using Vertica dialect

Explanation of the columns that may appear on this page:

Level A few code lists that FHIR defines are hierarchical - each code is assigned a level. In this scheme, some codes are under other codes, and imply that the code they are under also applies
System The source of the definition of the code (when the value set draws in codes defined elsewhere)
Code The code (used as the code in the resource instance)
Display The display (used in the display element of a Coding). If there is no display, implementers should not simply display the code, but map the concept into their application
Definition An explanation of the meaning of the concept
Comments Additional notes about how to use the code