I'm trying to understand the concept between schema and table. I read a lot but haven't found an answer to the following question. Could anyone explain it to me?
Schema: Describes the structure of data in the database. It includes definitions of tables, columns, data types, indexes etc. As someone wrote here: a better understanding of Schema in SQLServer it's a container for DB objects.
Table: Keeps data and has properties for each column. Which I understand is kept in a schema - right?
If I make a change in the property of a column for X table, do I also change the schema to which this table is attached?
If yes, then how does it affect different tables attached to the same schema?
Or maybe a schema is divided among all the tables? And it keeps separate information about tables X, Y, Z etc? And changes only schema for the table that was changed?