List databases and searching a specified database - Amazon Athena
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

List databases and searching a specified database

The examples in this section show how to list the databases in metadata by schema name.

Example– Listing databases

The following example query lists the databases from the information_schema.schemata table.

SELECT schema_name
FROM   information_schema.schemata
LIMIT  10;

The following table shows sample results.

6 alb-databas1
7 alb_original_cust
8 alblogsdatabase
9 athena_db_test
10 athena_ddl_db
Example– Searching a specified database

In the following example query, rdspostgresql is a sample database.

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name = 'rdspostgresql'

The following table shows sample results.

schema_name
1 rdspostgresql