Schema Change

Why Trust Techopedia

What Does Schema Change Mean?

A schema change is an alteration made to a collection of logical structures (or schema objects) in a database. Schema changes are generally made using structured query language (SQL) and are typically implemented during maintenance windows.

Advertisements

Techopedia Explains Schema Change

A schema is a general blueprint for how a database is structured. This includes a number of different tables, fields, keys and other organizational factors that, if altered, can cause complications in the database. Therefore, executable scripts are used to implement schema changes so that they can be properly implemented.

Advertisements

Related Terms

Margaret Rouse
Technology expert
Margaret Rouse
Technology expert

Margaret is an award-winning writer and educator known for her ability to explain complex technical topics 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 in 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 to help IT and business professionals to learn to speak each other’s highly specialized languages.