How to Create a Database in Redshift Cluster

Use below commands to create a new database in the Redshift Cluster.

CREATE DATABASE database_name;                                        

CREATE DATABASE database_name OWNER owner_name;                       

CREATE DATABASE database_name OWNER owner_name CONNECTION LIMIT value;

To change the owner of a database:

ALTER DATABASE database_name OWNER TO new_owner_name;  

To rename a database:

ALTER DATABASE database_name RENAME TO new_database_name;