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.
| 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]
List collections of the indicated database.
If database_name is not specified, this command will list the collections in the current database.
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
List views of the indicated database.
If database_name is not specified, this command will list the views in the current database.
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>]
List all of the fields of the indicated database and collection.
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>]
List all of the indexes for the indicated database and collection.
If collection_name is not specified, this command will list all the indexes in the indicated database.
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>]
List all of the index fields for the indicated database, collection and index.
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>]
List users of the indicated database and describe their USER_PERMISSIONS.
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>]
List the roles in the current database or the specified database. This is equivalent to MongoDB's db.runCommand({rolesInfo}) command.
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 |