> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions.md).

# Information Functions

Retrieve system and session metadata. This section details functions to access database names, user details, version info, and query statistics like row counts.

* [BENCHMARK](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/benchmark.md)
* [BINLOG\_GTID\_POS](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/binlog_gtid_pos.md)
* [CHARSET](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/charset.md)
* [COERCIBILITY](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/coercibility.md)
* [COLLATION](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/collation.md)
* [CONNECTION\_ID](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/connection_id.md)
* [CURRENT\_ROLE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/current_role.md)
* [CURRENT\_USER](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/current_user.md)
* [DATABASE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/database.md)
* [DECODE\_HISTOGRAM](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/decode_histogram.md)
* [DEFAULT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/default.md)
* [FOUND\_ROWS](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/found_rows.md)
* [LAST\_INSERT\_ID](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/last_insert_id.md)
* [LAST\_VALUE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/last_value.md)
* [PROCEDURE ANALYSE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/procedure-analyse.md)
* [ROW\_COUNT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/row_count.md)
* [ROWNUM](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/rownum.md)
* [SCHEMA](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/schema.md)
* [SESSION\_USER](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/session_user.md)
* [SYSTEM\_USER](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/system_user.md)
* [USER](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/user.md)
* [VERSION](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/version.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}
