Default Schema and Default Database

Most DBMS support the concept of default schema and default database, so that implicit naming can be used when referring to a database object.

For example, in SQL statements, you can refer to a table named t_customer in database crm simply as t_customer, instead of crm.t_customer, if your DMBS knows the default database is crm.

Before working on creating an ER Diagram or any other database objects, it is highly recommended to define the default schema object and the default database.

Default Schema

You will first define a schema object under the Text Objects tab and then assign it as the default schema under the Options tab.

  Please note that in MySQL, a schema object is just a synonym for a database object.  

Default Database

 For PostgreSQL, To define the default database, you will also go to the Options tab.