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: 383
        
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