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
SHOW DATABASES
SHOW DATABASES
List all available databases.
Example
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
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
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
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
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
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
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
The SHOW ROLES command is only available in MongoDB 2.6 and newer.
Example
SHOW ROLES IN mydatabase
Example
SHOW ROLES FOR ROLE myrole
SHOW STATUS
SHOW STATUS
Display server status. This is equivalent to the MongoDB's db.serverStatus() command.
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
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
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
SHOW SH_STATUS