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

# SHOW PACKAGE STATUS

## Syntax

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

## Description

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

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 STATUS LIKE 'pkg1'\G
*************************** 1. row ***************************
                  Db: test
                Name: pkg1
                Type: PACKAGE
             Definer: root@localhost
            Modified: 2018-02-27 14:38:15
             Created: 2018-02-27 14:38:15
       Security_type: DEFINER
             Comment: This is my first package
character_set_client: utf8
collation_connection: utf8_general_ci
  Database Collation: latin1_swedish_ci
```

## See Also

* [SHOW PACKAGE BODY](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-body-status.md)
* [SHOW CREATE PACKAGE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-package.md)
* [CREATE PACKAGE](/docs/server/reference/sql-statements/data-definition/create/create-package.md)
* [DROP PACKAGE](/docs/server/reference/sql-statements/data-definition/drop/drop-package.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" %}