-1

I hope I don't make myself completely ridiculous, but I'll have to admit that the definition database schema is not 100% clear to me.

I thought it would be some kind of a blueprint for my tables in my database. In terms of entity framework my DbContext would be my 'database schema'.

I began to realize that I am wrong reading this article (suggested in this question), where multi tenancy can be achieved by Shared Database, Separate Schemas.

Can somebody elaborate?

PS: I read this question but that doesn't really answer my somewhat n00bish question...

Community
  • 1
  • 1
bas
  • 13,550
  • 20
  • 69
  • 146

1 Answers1

2

The general understanding is as was explained in the question you referenced

schema : database : table :: floor plan : house : room

That is a schema is the blueprint for you database, and in that sense you DBContext + migrations could loosely be considered a database schema.

However there is also a second way the word schema is used in databases, and that is as a partitioned set (tenant) within the database. This is usually used for security.

All tables are defined within a specific schema (for example DBO) and when you query you are actually querying against tables in a specific schema hence 

SELECT * FROM [database].[schema].[table]

To answer your question there are 2 meanings to this, one is the english language meaning of the word, the other is the actual SQL meaning (which is to do with tenancy)

enter image description here

undefined
  • 33,537
  • 22
  • 129
  • 198