Chapter 7: Schema Creation and Management
In Chapter 6, How Indexes Work in CockroachDB, we learned what indexes are, how they are useful in improving query performance, the various types of indexes that are supported in CockroachDB, and the best practices while using indexes.
In this chapter, we will go through the syntax for various Structured Query Language (SQL) operations. Though we have learned some of the syntaxes throughout other chapters, it's useful to have all of them in a single place. Throughout this chapter, only commonly used query options are included, and some of the experimental and enterprise-only features have been left out.
The following topics will be covered in this chapter:
- DDL
- DML
- DQL
- Supported data types
- Column-level constraints
- Table joins
- Using sequences
- Managing schema changes
