How to get the name of the database in Redshift

Run the below query to return the name of the database you are currently connected to.

select current_database();
See also  How to drop a table in Redshift database