- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Environmental Science
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
What is a schema in SQL ?
Our database comprises of a lot of different entities such as tables, stored procedures, functions, database owners and so on. To make sense of how all these different entities interact, we would need the help of schema. So, you can consider schema to be the logical relationship between all the different entities which are present in the database.
Once we have a clear understanding of the schema, this helps in a lot of ways:
- We can decide which user has access to which tables in the database.
- We can modify or add new relationships between different entities in the database.
Overall, you can consider a schema to be a blueprint for the database, which will give you the complete picture of how different objects interact with each other and which users have access to different entities.
- Related Questions & Answers
- What is SQL injection ?
- What is a schema in SQL ?
- What is Primary Key in SQL ?
- What is a unique key in SQL ?
- What is OLAP ?
- How do I view tables in SQL ?
- How to delete a table in SQL ?
- What is Normalization in SQL ?
- How to change a table name in SQL ?
- How to delete a row in SQL ?
- How to insert date in SQL ?
- What is OLTP ?
- What are Nested Triggers ?
- What is SQL ?
- What is SQL server ?
- What is PL/SQL ?
Advertisements
ads