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 ...
Get Getting Started with CockroachDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
