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
Updated on: 25-Mar-2021
2K+ Views
Advertisements