Thread: What is Shema in database?

What is Shema in database?

you mean Schema?

Schemas are generally stored in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure.

schema is i thing structure of data base.

A database schema is described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields in each table, and the relationships between fields and tables

hi

schema is same database overall structure of tables and data base.

When you are going to create your database in database software than first you draw graphically whole database that is known as schema.

I am Useing this Schemas function all data store in database command directory

Database schema defines relationship between table, and field in each table.
Schema classification:

1. Conceptual schema, a map of concepts and their relationships
2. Logical schema, a map of entities and their attributes and relations
3. Physical schema, a particular implementation of a logical schema
4. Schema object, Oracle database object
5. Schema is the over all structure of the database

in short, it is structure of database

Itz not shema itz schema....

A database schema is a way to logically group objects such as tables, views, stored procedures etc. So you can think of a schema as a container of objects.
You can assign a user log in permissions to a single schema so that the user can only access the objects they are authorized to access.