How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Ameen Khan Your Own Question
Ameen Khan
Ameen Khan,
Category: Computer
Satisfied Customers: 11878
Experience:  Senior IT Support Specialist at Brookfield Asset Management
101830517
Type Your Computer Question Here...
Ameen Khan is online now

What is the purpose of Schemas in SQL Server in plain

This answer was rated:

What is the purpose of Schemas in SQL Server in plain English without much jargon ?I require a good detailed example.

Hi! My name is Ameen and I'll be assisting you. Secure Remote Assistance is NOT REQUIRED (But Helpful)

I am sorry you are having this concern, I will do my best to help you today.

To answer your question ->

Schema in SQL Server is used to Manage many logical entities in one physical database. These Schemas make it easy to separate and distinguish database users from the database object owners preset. They also give these DBAs the ability to host and protect sensitive objects within the database, and group logical entities together.

-------------

I hope my answer was helpful to you and If you would like more assistance, feel free to message me back. I am here to help you.

Customer: replied 5 months ago.
Thanks. Can you provide a comprehensive example please ?

A visual example would be best to understand, have a look here - https://www.youtube.com/watch?v=56QVuEh4BvA

Ameen Khan and 3 other Computer Specialists are ready to help you
Customer: replied 5 months ago.
Thanks

You're welcome. Pleasure assisting you. Thanks for allowing me to help you out today.