---
title: "DB2 Schema quick tutorial"
description: "A schema in DB2 is a logical grouping of database objects. It also is used for name qualifiers, which help naturally organize database objects by their name."
url: https://srinimf.com/2015/12/12/are-you-ready-to-know-db2-schema-read-this-3-key-points/
date: 2015-12-12
modified: 2026-10-10
author: "Srini"
categories: ["DB2 V10"]
tags: ["3 Key Points on DB2 Schema"]
type: post
lang: en
---

# DB2 Schema quick tutorial

A *schema *is a logical grouping of database objects. It also is used for name qualifiers, which help naturally organize database objects by their name. The convention for this is .. This also allows more than on object to have the same object name as long as each is in a different schema.

For example, if you sold [hardware and software](https://srinimf.com/2023/02/20/ai-development-hardware-and-software-you-need/), you could have a HARDWARE and SOFTWARE schema. In each of them, you could have an ORDERS table to differentiate between hardware and software orders (HARDWARE.ORDERS and SOFTWARE.ORDERS).

If a schema is not qualified, or explicitly stated when the object is created, the schema name is the user ID of the user who created the object. If I am logged in as db2 user and create a table named TEMP1, the full name of that table would be DB2USER.TEMP1.

Related[DB2: List of Top Table Spaces Quick Tutorial](https://srinimf.com/2014/10/03/db2-revolving-tablespacesrotating-partitions/)

Recent Posts

Related[5 Reasons Why You need Qualified SSAs in IMS DB DL/I Calls](https://srinimf.com/2016/06/13/qualified-ssas-in-ims-db-dli-calls-5-reasons-why-you-need/)

- [30 SQL Practice Queries with Solutions — Run Them Live](https://srinimf.com/2026/10/01/30-sql-practice-queries-with-solutions-run-them-live/)
- [Supercharge Your Database Skills: Try Our New Interactive SQL Plugin!](https://srinimf.com/2026/09/30/supercharge-your-database-skills-try-our-new-interactive-sql-plugin/)
- [How to Count Spark Stages by Sight and Optimize Shuffles](https://srinimf.com/2026/09/27/how-to-count-spark-stages-by-sight-and-optimize-shuffles/)
- [Databricks Cluster Min & Max: How to Find and Right-Size](https://srinimf.com/2026/09/19/databricks-cluster-min-max-how-to-find-and-right-size/)
- [Tony Robbins Vocabulary: 50 Powerful Words and Phrases to Improve Your English](https://srinimf.com/2026/08/30/tony-robbins-vocabulary-50-powerful-words-and-phrases-to-improve-your-english/)

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2015%2F12%2F12%2Fare-you-ready-to-know-db2-schema-read-this-3-key-points%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2026%2F02%2Fcropped-logo.png%3Ffit%3D96%252C96%26ssl%3D1&description=DB2%20Schema%20quick%20tutorial)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2015/12/12/are-you-ready-to-know-db2-schema-read-this-3-key-points/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2015/12/12/are-you-ready-to-know-db2-schema-read-this-3-key-points/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2015/12/12/are-you-ready-to-know-db2-schema-read-this-3-key-points/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2015/12/12/are-you-ready-to-know-db2-schema-read-this-3-key-points/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%20Schema%20quick%20tutorial&body=https%3A%2F%2Fsrinimf.com%2F2015%2F12%2F12%2Fare-you-ready-to-know-db2-schema-read-this-3-key-points%2F&share=email)
-

### Like this:

Like Loading…