> 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-package-body-status.md).

# SHOW PACKAGE BODY STATUS

## Syntax

```bnf
SHOW PACKAGE BODY STATUS
    [LIKE 'pattern' | WHERE expr]
```

## Description

The `SHOW PACKAGE BODY STATUS` statement returns characteristics of stored package bodies (implementations), such as the database, name, type, creator, creation and modification dates, and character set information. A similar statement, [SHOW PACKAGE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-status.md), displays information about stored package specifications.

The `LIKE` clause, if present, indicates which package names to match. The `WHERE` and `LIKE` clauses can be given to select rows using more general conditions, as discussed in [Extended SHOW](/docs/server/reference/sql-statements/administrative-sql-statements/show/extended-show.md).

The [ROUTINES table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-routines-table.md) in the INFORMATION\_SCHEMA database contains more detailed information.

## Examples

```sql
SHOW PACKAGE BODY STATUS LIKE 'pkg1'\G
*************************** 1. row ***************************
                  Db: test
                Name: pkg1
                Type: PACKAGE BODY
             Definer: root@localhost
            Modified: 2018-02-27 14:44:14
             Created: 2018-02-27 14:44:14
       Security_type: DEFINER
             Comment: This is my first package body
character_set_client: utf8
collation_connection: utf8_general_ci
  Database Collation: latin1_swedish_ci
```

## See Also

* [SHOW PACKAGE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-status.md)
* [SHOW CREATE PACKAGE BODY](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-package-body.md)
* [CREATE PACKAGE BODY](/docs/server/reference/sql-statements/data-definition/create/create-package-body.md)
* [DROP PACKAGE BODY](/docs/server/reference/sql-statements/data-definition/drop/drop-package-body.md)
* [Oracle SQL\_MODE](/docs/release-notes/community-server/about/compatibility-and-differences/sql_modeoracle.md)

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

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