Skip to main content

USE and SHOW

  • use <database>: Switch current database.
  • show dbs / show databases: Show all databases.
  • show collections: Show all collections in the current database.
  • show tables: Same as show collections.
  • show users: Show users.
  • show roles: Show roles.
  • show profile: Query profiling records.