I am new in the CS field, and one thing is that before asking this question I already googled it, but that made me more confused between two definitions I have found, so I'm asking which one is correct? So in this link, I found multiple answers which one is correct? What is the purpose of database schema?
I found this. What's confusing for me I think is that they both definitions are different from each other Guide me..
1) A SQL schema is container of objects. For example, you may have a large enterprise application and then it's a good practice to use different schemas for different purposes (e.g. put HR related tables into HR schema, accounting related tables into Accounting schema and so on). A schema can be owned by any user, and the ownership is transferable.
2)the database schema is the definition that describes the entire configuration of the database, including all of its tables, relations, index, etc
my question is different I have read the multiple answers which are available but I found multiple answers that is what made me more confused