---
title: "Comment by Richard Uie on \"Differences Between SQL And NoSQL Databases\" | Hashnode"
description: "&quot;In a SQL database, there is a schema that sets the rules for how tables are related to each other.&quot; You may be confusing the notion of schema as it r"
url: "https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b/comment/5ca70382d71e2d342caff53d"
---

[Discussion](https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b)

Comment [Differences Between SQL And NoSQL Databases](https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b)

[Richard Uie](https://hashnode.com/@RichardUie)

[Apr 5, 2019](https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b/comment/5ca70382d71e2d342caff53d)

"In a SQL database, there is a schema that sets the rules for how tables are related to each other."

You may be confusing the notion of schema as it relates to XML documents. Here's a good resource for how IBM DB2 deals with the idea of [Schemas](https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004105.html).

"Rigid, predefined schema that needs to be updated for new columns"

Simple ALTER TABLE operations can ADD (or DROP) columns and would rarely affect or be affected by a schema.

~~~~~~~~~~~~~~~

Days Later Without Reply...

Well all-righty then, since Milecia seems uninclined to correct herself, I will re-emphasize what I said.

Milecia's representations about schemas for RBDMSs are flatly wrong.

Schemas serve very little purpose in RDBMSs other than providing namespace organization for collections of database objects - mainly, they prevent naming collisions and reserve certain organizational ideas, e.g., the SYSIBM schema for DB2.

Columns are not database objects and would only influence or be influenced by schemas, if part or whole of an index (primary or foreign key or performance index...those, not simple columns ARE database objects) came into play, either deleting a column that was part of an index or adding a column that would become part of an index.

Sorry, Milecia, be more careful when you attempt to teach. Especially, don't _teach_ wrong stuff.

[Milecia](https://hashnode.com/@flippedcoding)

[Apr 9, 2019](https://hashnode.com/posts/differences-between-sql-and-nosql-databases/5ca5e268c1144c044d13c35b/comment/5ca70382d71e2d342caff53d#reply-5caca50ae80ebf2f7b830eaf)

Hey [Richard Uie](https://hashnode.com/@RichardUie). Sorry it took a while for me to get back to you because you know, life.

I was talking about the XML documents. I'll have to update it when I get a chance.

Thanks for pointing it out for others! Even teachers screw up sometimes. 🙂
