Page History
The following SHOW commands can be used to describe MongoDB schema information. See the SQL Query Reference for information on Utility Statements and Configuration Functions.
Contents
| Anchor |
|---|
...
|
...
|
...
| Table of Contents |
|---|
...
|
SHOW DATABASES
SHOW DATABASES
List all available databases.
Example
| Code Block |
|---|
SHOW DATABASES |
...
SHOW COLLECTIONS
SHOW COLLECTIONS [IN <database_name>] [FOR COLLECTION <collection_name>] [NAMES_ONLY]
...
The NAMES_ONLY option retrieves the collection name only and the storage data is not included in the result set.
Example
| Code Block |
|---|
SHOW COLLECTIONS IN statistics |
...
SHOW VIEWS
SHOW VIEWS [IN <database_name>] [FOR VIEW <view_name>] [NAMES_ONLY] New in 19.0
...
The NAMES_ONLY option retrieves the view name only and the options data is not included in the result set.
Example
| Code Block |
|---|
SHOW VIEWS IN statistics |
...
SHOW FIELDS
SHOW FIELDS IN <collection_name> [IN <database_name>]
...
If database_name is not specified, this command defaults to the current database.
Example
| Code Block |
|---|
SHOW FIELDS IN baseballstats IN statistics |
...
SHOW INDEXES
SHOW INDEXES [IN <database_name>] [FOR COLLECTION <collection_name>]
...
If database_name is not specified, this command defaults to the current database.
Example
| Code Block |
|---|
SHOW INDEXES IN statistics FOR COLLECTION baseballstats |
...
SHOW INDEXFIELDS
SHOW INDEXFIELDS IN collection_name [IN <database_name>] [FOR INDEX <index_name>]
...
If database_name is not specified, this command defaults to the current database.
Example
| Code Block |
|---|
SHOW INDEXFIELDS IN baseballstats IN statistics FOR INDEX batter_id_index |
...
SHOW USERS
SHOW USERS [IN <database_name>] [FOR USER <user_name>]
...
If database_name is not specified, this command defaults to the current database.
Example
| Code Block |
|---|
SHOW USERS IN statistics |
...
SHOW ROLES
SHOW ROLES [IN <database_name>] [FOR USER <role_name>]
...
If database_name is not specified, this command defaults to the current database. The following columns are displayed for SHOW ROLE: role, db, isBuiltin, roles, inheritedRoles, privileges, inheritedPrivileges
| Info |
|---|
The SHOW ROLES command is only available in MongoDB 2.6 and newer. |
Example
| Code Block |
|---|
SHOW ROLES IN mydatabase |
...
Example
| Code Block |
|---|
SHOW ROLES FOR ROLE myrole |
...
SHOW STATUS
SHOW STATUS
Display server status. This is equivalent to the MongoDB's db.serverStatus() command.
| Info |
|---|
The SHOW STATUS command will only work if you are an "admin" user. In MongoDB version 2.2, you need to be able to log in to the "admin" database. In MongoDB version 2.4, you need to have the clusterAdmin role in the "admin" database. |
Example
| Code Block |
|---|
SHOW STATUS |
...
SHOW RS_STATUS
SHOW RS_STATUS
Display the list of members in a replica set. This is equivalent to members field returned from the MongoDB's replSetGetStatus command.
The SHOW RS_STATUS command will only work if you are an "admin" user. In MongoDB version 2.2, you need to be able to log in to the "admin" database. In MongoDB version 2.4, you need to have the clusterAdmin role in the "admin" database.
Example
| Code Block |
|---|
SHOW RS_STATUS |
...
SHOW SH_STATUS
SHOW SH_STATUS
Display the list of shards in a sharded cluster. This is equivalent to the MongoDB's listShards command.
The SHOW SH_STATUS command will only work if you are an "admin" user. In MongoDB version 2.2, you need to be able to log in to the "admin" database. In MongoDB version 2.4, you need to have the clusterAdmin role in the "admin" database.
Example
| Code Block |
|---|
SHOW SH_STATUS |
...