There are three types of user-defined functions in SQL, namely:

1.Scalar Functions
2.Inline Table-valued functions
3.Multi-statement valued functions

Scalar returns the unit, variant defined the return clause. The other two types of defined functions return table.