Database Schema

What Does Database Schema Mean?

A database schema is a visual and logical architecture of a database created on a database management system.

Advertisements

It provides a graphical view of the entire database architecture and structure. It provides a means for logically grouping and displaying database objects such as tables, fields, functions and relations.

Techopedia Explains Database Schema

A database schema typically shows the different tables, their fields and the relationship between them and other tables. The database schema is defined within the native database language; therefore the logical structure and visualization of schema might vary in each database language. It helps database administrators in understanding the architectural layout of the database.

In addition to tables and fields, a database schema defines a database’s:

  • Indexes
  • Views
  • Triggers
  • Database links
  • Events
  • Procedures
  • Functions
Advertisements

Related Terms

Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.