Can I SELECT all the bult-in functions in SQL Server?

Is it possible to display every built-in function (like LEFT, SIN, IIF etc.) with a query?

Answer

Documentation or syntax highlighting definition from official tool:

Azure Data Studio – syntax support

{
"match": "(?i)\b(avg|checksum_agg|count|count_big|grouping|grouping_id|max|min|sum|stdev|stdevp|var|varp)\b",
"name": "support.function.aggregate.sql"
},
{
"match": "(?i)\b(cast|convert|parse|try_cast|try_convert|try_parse)\b",
"name": "support.function.conversion.sql"
},  ...

Searching for: “name”: “support.function

---

Idea – Not tested: Maybe it is possible to extract that data from system database – Resource

Resource Database

The Resource database is a read-only database that contains all the system objects that are included with SQL Server.