> 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/miscellaneous-functions/sys_guid.md).

# SYS\_GUID

{% hint style="info" %}
`SYS_GUID` is available from MariaDB [10.6.1](/docs/release-notes/community-server/10.6/10.6.1.md).
{% endhint %}

The `SYS_GUID` function was introduced to enhance Oracle compatibility. Similar functionality can be achieved with the [UUID](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid.md) function.

## Syntax

```bnf
SYS_GUID()
```

## Description

Returns a 16-byte globally unique identifier (GUID), similar to the [UUID](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid.md) function, but without the `-` character.

## Example

```sql
SELECT SYS_GUID();
+----------------------------------+
| SYS_GUID()                       |
+----------------------------------+
| 2C574E45BA2811EBB265F859713E4BE4 |
+----------------------------------+
```

## See Also

* [UUID](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid.md)
* [UUID\_SHORT](/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid_short.md)
* [UUID data type](/docs/server/reference/data-types/string-data-types/uuid-data-type.md)

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

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