Have you ever wondered how to work with your fellows in one database without interfering with each other? Is it possible to organize the database objects into logical groups which do not collide with the other objects' names?
We can do those things with Schema.
A schema is a collection of tables. A schema also contains views, indexes, sequences, data types, operators, and functions. We support multiple schemas. For example, you can have a database named oxla and have multiple schemas based on your needs, like auth, model, business, etc.
By default, the public schema is used in Oxla.
When unqualified table_name is used, that table_name is equivalent to public.table_name. It also applies to CREATE, DROP, and SELECT TABLE statements.
💡 Furthermore, you can create multiple schemas per your needs.
The basic syntax of creating a schema is as follows:
schema_name is the name of the schema you are going to create.
The syntax to create a table in a specified schema is as follows:
- schema_name is the schema that you have created.
- table_name is the table name you are going to create.
After creating the table and inserting some data, display all rows with the syntax below:
- schema_name is the name of the schema.
- table_name is the name of the table you want to display.
To drop an empty schema where no objects remain in it, use the command below:
Tables reside in a schema, so it is impossible to drop a schema without also dropping the tables. With the command below, you will also drop the schema with the tables.
1) First, connect to Oxla and create a schema as shown below:
2) Next, create a table in the above schema with the following details:
3) You can verify and show the table made with the command below:
4) You will get the following result:
From Example #1, we created a new schema and a table. Use the command below to delete the schema and also the tables in it:
Another case is if there is no table or object created inside the schema, you can use the following command to drop the schema: