Versions Compared

Old Version 7

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version Current

changes.mady.by.user Nadine Hinojosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
backtotop
backtotopBack to TopBack to Top

Table of Contents
stylenone

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]
...
 Code Block
SHOW COLLECTIONS IN statistics
Back to top
SHOW VIEWS
SHOW VIEWS [IN <database_name>] [FOR VIEW <view_name>] [NAMES_ONLY] New in 19.0
...
 Code Block
SHOW VIEWS IN statistics
Back to top
SHOW FIELDS
SHOW FIELDS IN <collection_name> [IN <database_name>]
...
 Code Block
SHOW FIELDS IN baseballstats IN statistics
Back to top
SHOW INDEXES
SHOW INDEXES [IN <database_name>] [FOR COLLECTION <collection_name>]
...
 Code Block
SHOW INDEXES IN statistics FOR COLLECTION baseballstats
...
SHOW INDEXFIELDS
SHOW INDEXFIELDS IN collection_name [IN <database_name>] [FOR INDEX <index_name>]
...
 Code Block
SHOW INDEXFIELDS IN baseballstats IN statistics FOR INDEX batter_id_index
Back to top
SHOW USERS
SHOW USERS [IN <database_name>] [FOR USER <user_name>]
...
 Code Block
SHOW ROLES FOR ROLE myrole
Back to top
SHOW STATUS
SHOW STATUS
Display server status. This is equivalent to the MongoDB's db.serverStatus() command.
...
Example
 Code Block
SHOW STATUS
Back to top
SHOW RS_STATUS
SHOW RS_STATUS
...
Example
 Code Block
SHOW RS_STATUS
...
SHOW SH_STATUS
SHOW SH_STATUS
...
Example
 Code Block
SHOW SH_STATUS
Back to top