In the context of relational databases, the terms "database" and "schema" are often used interchangeably, but they have different meanings.
A database is a collection of related data stored in a specific and organized way, allowing for easy retrieval and management of the data. A database can contain multiple tables, views, and other database objects.
A schema is a logical container for organizing database objects, such as tables, views, indexes, procedures, and functions, within a database. A schema provides a way to organize the database objects in a logical and meaningful manner.
In other words, a schema can be thought of as a blueprint or blueprint plan of how the database is structured and how the data is organized within it. A database can contain multiple schemas, and each schema can contain multiple tables and other objects.
In short, a database is a physical container for storing data, while a schema is a logical container for organizing the database objects within that data.
'데이터베이스 > mySQL' 카테고리의 다른 글
| prisma 와 nexus 의 차이가 뭐야? (0) | 2023.02.19 |
|---|---|
| how to handle Error 'ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database '' (0) | 2023.02.09 |
| how to fix Error 'SELECT command denied to user ''@'localhost' for table `mysql`.`user`' in dbeaver (0) | 2023.02.08 |
| The difference between "mysql" and "mysql -u root -p" (0) | 2023.02.08 |
| mysql EVENT스케줄러 (자동생성) (0) | 2022.05.18 |