What is the use of a schema in SQL Server?
Advantage of Schema:-
Advantage of Schema:-
- Act as object protection tool: A schema can be a very effective object projection tool combined with the appropriate level of user permissions.
- A DBA can maintain control access to an object that would be very crucial.
- Easy to maintain the database.
- A single schema can be shared among multiple databases and database users.
- A database user can be dropped without dropping database objects.
- Manipulation of and access to the object is now very complex and more secure. The schema acts as an additional layer of security.
- Database objects can be moved among schemas.
- The ownership of schemas is transferable