SQL Four-Part Names

The four-part names of SQL Server objects. How to reference objects in SQL Server by their four-part name and how to use it in a T-SQL statement.

Working with Schemas

What is the schema object in SQL Server? How is the schema object used for organization, naming, and security?

What is a Schema?

The term schema could mean several different things. What are the different meanings and how are schemas are used in SQL Server.