a) I found two definitions of schema:
FIRST - A set of information that describes a table is known as a schema,
and schemas are used to describe specific tables within a database, as well
as entire databases (and the relationship between tables in them, if any).
SECOND - A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects.
I assume the two descriptions describe entirely different concepts, which just happen to use the same name?
b)
A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects.
If I understand the above definition correctly, then database schema is similar to a namespace, only difference being that we can assign access permissions to database schema, while same can’t be done with namespaces?
thanx
