0

I've tried to find the distinction between the terms database and a database schema. I've seen some answers in Stack Overflow itself but they were not sufficient to get a good idea of the differences between the two. Can someone please explain this comprehensively with details.

Also, I've read that DDL is used on schema and not on the database. What does this mean?

Is it true if I call a schema being a sub-set of a database?

Thanks in advance!

  • Does this answer your question? [Difference Between Schema / Database in MySQL](https://stackoverflow.com/questions/11618277/difference-between-schema-database-in-mysql) – P.Salmon Feb 03 '21 at 11:02
  • Thanks. But the answer provided here says that in MySQL both are synonymous. Suppose this is a question asked in an exam paper, what must my answer be? –  Feb 03 '21 at 11:06
  • Also, I've read that DDL is used on schema and not on the database. What does this mean? –  Feb 03 '21 at 11:07
  • Is it true if I call a schema being a sub-set of a database? –  Feb 03 '21 at 11:10
  • Not in mysql's case and you should read up on DDL (data definition language) and DML (data manipulation language) – P.Salmon Feb 03 '21 at 11:11

0 Answers0