This page is part of the book SQL-99 Complete, Really, by Peter Gulutzan & Trudy Pelzer. The authors have graciously allowed us to reproduce the contents of the book here. Because the book is about the SQL-99 standard, the contents of this and other pages in the book may not directly apply to MariaDB. Use the navigation bar to navigate the book.

The SQL Standard describes the concepts on which SQL is based in terms of Objects, such as Tables. Most of these Objects are Schema Objects; that is, they depend on some Schema. In this chapter, we'll describe SQL Schemas in detail, and show you the syntax to use to create, alter and destroy them.