Schema
A SQL database
contains multiple objects such as tables, views, stored procedures, functions,
indexes, triggers. We define SQL Schema as a logical collection of database
objects. A user owns that owns the schema is known as schema owner. It is a
useful mechanism to segregate database objects for different applications,
access rights, managing security administration of databases. We do not have
any restrictions on the number of objects in a schema.
No comments:
Post a Comment