Discussion in 'Getting Started' started by reethu, Dec 9, 2009.
SOme one can provide advantages and disadvantages in implementing Schemas in prod environment.
Schema in SQL Server is an object that conceptually holds definitions for other database objects such as tables,views,stored procedures etc. The main advantage of creating a schema is that you can grant permissions to database objects by a single CREATE SCHEMA statement.Objects belonging to a schema are said to be schema bound.When creating an index view,the view has to be schema bound.Base objects such as a table or a view cannot be dropped when a schema-bound object such as a view is created on it.
From the BOOKS ONLINE (BOL): A schema is a container that holds tables, views, procedures, and so on. It is inside a database, which is inside a server. These entities fit together like nested boxes. The server is the outermost box, and the schema is the innermost box. It holds all of the securables listed below. But it cannot hold another box.
For sure there are no disadvantages of using this way.
Separate names with a comma.