You're reading from Getting Started with CockroachDB A guide to using a modern, cloud-native, and distributed SQL database for your data-intensive apps

Product type Paperback

Published in Mar 2022

Publisher Packt

ISBN-13 9781800560659

Length 246 pages

Edition 1st Edition

Languages

SQL

Tools

CockroachDB

Concepts

Databases

Author (1):

Kishen Das Kondabagilu Rajanna

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Getting to Know CockroachDB

2. Chapter 1: CockroachDB – A Brief Introduction FREE CHAPTER

3. Chapter 2: How Does CockroachDB Work Internally?

4. Section 2: Exploring the Important Features of CockroachDB

5. Chapter 3: Atomicity, Consistency, Isolation, and Durability (ACID)

6. Chapter 4: Geo-Partitioning

7. Chapter 5: Fault Tolerance and Auto-Rebalancing

8. Chapter 6: How Indexes Work in CockroachDB

9. Section 3: Working with CockroachDB

10. Chapter 7: Schema Creation and Management

11. Chapter 8: Exploring the Admin User Interface

12. Chapter 9: An Overview Of Security Aspects

13. Chapter 10: Troubleshooting Issues

14. Chapter 11: Performance Benchmarking and Migration

15. Other Books You May Enjoy

Appendix: Bibliography and Additional Resources

Why subscribe?

Database and table definitions

The Databases dashboard contains the list of databases, with a list of tables in them. You can also view grants given to various users.

In the following screenshot, you can see the Databases dashboard, with options to view Tables and Grants:

Figure 8.7 – Databases dashboard showing the tables and grants options in the dropdown

If you select the Tables option, you will see a list of tables for all the databases with some stats. If the stats are not loaded, you can click on the Load stats for all tables option to populate the table-level stats, as can be seen in the following screenshot:

Figure 8.8 – Databases dashboard showing tables

From this dashboard, you can also view the DDLs for all the tables, as shown in the following screenshot:

Figure 8.9 – Databases dashboard showing the DDLs of tables

Grants will show user-level permissions with respect to a...