> 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-statements/administrative-sql-statements/show/show-plugins-soname.md).

# SHOW PLUGINS SONAME

## Syntax

```bnf
SHOW PLUGINS SONAME { library | LIKE 'pattern' | WHERE expr };
```

## Description

`SHOW PLUGINS SONAME` displays information about compiled-in and all server plugins in the [plugin\_dir](/docs/server/reference/plugins/plugin-overview.md) directory, including plugins that haven't been installed.

## Examples

```sql
SHOW PLUGINS SONAME 'ha_example.so';
+----------+---------------+----------------+---------------+---------+
| Name     | Status        | Type           | Library       | License |
+----------+---------------+----------------+---------------+---------+
| EXAMPLE  | NOT INSTALLED | STORAGE ENGINE | ha_example.so | GPL     |
| UNUSABLE | NOT INSTALLED | DAEMON         | ha_example.so | GPL     |
+----------+---------------+----------------+---------------+---------+
```

There is also a corresponding [information\_schema](/docs/server/reference/system-tables/information-schema.md) table, called [ALL\_PLUGINS](/docs/server/reference/system-tables/information-schema/information-schema-tables/all-plugins-table-information-schema.md), which contains more complete information.

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

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