• I love schemas for 2 reasons

    1) Organisation

    Grouping tables as belonging together in a logical group.

    For example from the AdventureWorks db > HumanResources.Employee , Person.Address , Sales.CreditCard.

    2) Security

    Permissions assigned at schema level make it easier to control relevant access to developers etc by subject area. Teams working on separate parts of a project can have different permissions within a db.

    Application logins from different software components can have only the permissions they need.

    Yes this can be done on an object level, but how much easier is it to do via schema from the start.

    It will be one command versus many when granting access to a set of objects when grouping them by schema.