SQL Schema

What is SQL Schema?

  • SQL schema is a structure which represents the logical view of the entire database.
  • SQL schema is used to define how the data is organized and how the relations among them are associated.
The SQL schema can be divided into two categories are as follows,
1. Physical Database Schema
2. Logical Database Schema

1. Physical Database Schema
  • Physical schema is used in data management system.
  • It is used to describe how the data will be stored in the secondary storage.
  • It is related to the actual storage of data and its form of storage like files, indices etc.
2. Logical Database Schema
  • Logical database schema defines all the logical constraints that need to be applied on the data stored.
  • This schema defines the tables, views and integrity constraints.
▲