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.

With DataRow, you don’t need to write SQL queries every time you want to take Schemas actions.

DataRow allows you to CREATE, ALTER or DELETE Schemas easily just with a single click.


Ready to use DataRow?

Get started with a free trial for your business.

Start My 14-day trial