As described at Amazon’s Schemas Documentation, a database contains one or more named schemas. Each schema in a database contains tables and other kinds of named objects.
By default, a database has a single schema, which is named PUBLIC. You can use schemas to group database objects under a common name. Schemas are similar to operating system directories, except that schemas cannot be nested.
Schemas can help with organization and concurrency issues in a multi-user environment in the following ways:
- To allow many developers to work in the same database without interfering with each other.
- To organize database objects into logical groups to make them more manageable.
- To give applications the ability to put their objects into separate schemas so that their names will not collide with the names of objects used by other applications.