Tabular

Tabular functions return a result set — a table of rows — rather than a single scalar value.

Function	Description
fn_builtin_permissions	Returns a description of the all built-in permissions hierarchy of the server.
fn_helpcollations	Returns a list of all collations.
fn_listextendedproperty	Returns extended property values of database objects.
OPENJSON	Parses JSON text into rows and columns.
OPENQUERY	Runs a query on a connected source.
OPENROWSET	Reads external data as a table.