- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference Between Schema and Instance
In this post, we will understand the difference between a schema and an instance.
Schema
It is defined as the overall description of the database.
It remains the same for the entire database.
It doesn’t change frequently.
It is used to define the basic structure of the database.
It tells about how the data would be stored in a database.
Instance
It refers to the collection of information that is stored in the database at a specific moment.
Data in these instances can be changed.
This can be done using addition, deletion, and updating.
The instance changes frequently.
It is the set of Information that is stored at a particular time
Advertisements