Two different definitions of database schema

Posted by AspOnMyNet on Stack Overflow See other posts from Stack Overflow or by AspOnMyNet
Published on 2010-04-28T18:54:23Z Indexed on 2010/04/28 18:57 UTC
Read the original article Hit count: 319

Filed under:
|
|

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

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server