Server vs Database vs Schema

SQL Server vs Database vs Schema vs Table

SQL Server
└── Database
    └── Schema
        └── Table
            └── Rows and Columns

1. SQL Server

SQL Server is Microsoft’s database management software.

• Manages multiple databases

• Provides security, backup and recovery

• Executes SQL queries

Example:

PROD-SQL01

2. Database

A database is a container inside SQL Server that holds related data and objects.

It contains:

• Schemas

• Tables

• Views

• Stored procedures

• Functions

Example:

CREATE DATABASE SalesDB;

3. Schema

A schema organizes database objects into logical groups.

Examples:

sales.Customers
hr.Employees
audit.Logs

Here, sales, hr, and audit are schemas.

Benefits:

• Organizes objects

• Prevents naming conflicts

• Simplifies permission management

dbo is the commonly used default schema.

4. Table

A table stores the actual data in rows and columns.

CREATE TABLE sales.Customers
(
    CustomerId INT PRIMARY KEY,
    CustomerName VARCHAR(100)
);

• Columns: CustomerId, CustomerName

• Row: One customer record

Main Differences

Simple Example

Think of an office building:

• SQL Server → Building

• Database → Company

• Schema → Department

• Table → Filing cabinet

• Row → One record

• Column → One type of information

Key Points

• One SQL Server can contain multiple databases.

• One database can contain multiple schemas.

• One schema can contain multiple tables.

• Tables store the actual data.

• Common object format:

Database.Schema.Table

Example:

SELECT * FROM SalesDB.sales.Customers;