---
title: "Relational operators (Transact-SQL)"
description: "Relational operators (Transact-SQL)"
author: rwestMSFT
ms.author: randolphwest
ms.reviewer: ""
ms.date: 05/09/2022
ms.prod: sql
ms.prod_service: "sql-database"
ms.technology: t-sql
ms.topic: reference
ms.custom:
  - "event-tier1-build-2022"
helpviewer_keywords:
  - "Relational operators [Transact-SQL], about operators"
  - "Relational operators [Transact-SQL]"
dev_langs:
  - "TSQL"
---

# Relational operators (Transact-SQL)

A relational operator is a syntax element that can accept one or more named or unnamed input parameters and returns a result set. Relational operators are used as table source in a DML statement.

SQL Server implements the following relational operators:

- [GENERATE_SERIES (Transact-SQL)](../functions/generate-series-transact-sql.md)
- [OPENDATASOURCE (Transact-SQL)](../functions/opendatasource-transact-sql.md)
- [OPENQUERY (Transact-SQL)](../functions/openquery-transact-sql.md)
- [OPENROWSET (Transact-SQL)](../functions/openrowset-transact-sql.md)
- [OPENXML (Transact-SQL)](../functions/openxml-transact-sql.md)
- [OPENJSON (Transact-SQL)](../functions/openjson-transact-sql.md)
- [PREDICT (Transact-SQL)](../queries/predict-transact-sql.md)
- [STRING_SPLIT (Transact-SQL)](../functions/string-split-transact-sql.md)

## Use

Use a relational operator like a [table-valued function](../statements/create-function-transact-sql.md#c-creating-a-multi-statement-table-valued-function) in a query or T-SQL statement. 

## See also

[What are the SQL database functions?](../functions/functions.md)