Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql: Document system database #1291

Closed
sploiselle opened this issue Apr 13, 2017 · 4 comments
Closed

sql: Document system database #1291

sploiselle opened this issue Apr 13, 2017 · 4 comments
Assignees
Labels
P-1 High priority; must be done this release T-missing-info

Comments

@sploiselle
Copy link
Contributor

Briefly mentioned in #1160, but the tables of the system database should each be documented.

We don't see many questions about this currently (so I don't think it meets the 1.0 milestone requirement), but think it warrants documentation.

Currently the only reference to the system database is in Learn CockroachDB SQL, which says:

CockroachDB comes with a single default system database, which contains CockroachDB metadata and is read-only.

@rmloveland
Copy link
Contributor

I think this should be internal engineering/support documentation. IIRC, users should not be doing anything with the system database other than knowing it exists and is used by the system. What do you think @sploiselle ? Can I convince you of this position? 🙂

@rmloveland
Copy link
Contributor

users should not be doing anything with the system database

After reading some internal discussion about tables that live in system.* I realize this is not a correct opinion. :-)

@rmloveland rmloveland added P-2 Normal priority; secondary task and removed P-3 Low priority; nice-to-have labels Jan 30, 2019
@rmloveland
Copy link
Contributor

E.g., DELETE FROM system.table_statistics WHERE name LIKE '%foo%';

@ericharmeling ericharmeling added P-1 High priority; must be done this release and removed P-2 Normal priority; secondary task labels Apr 15, 2021
@ericharmeling ericharmeling self-assigned this Apr 15, 2021
@ericharmeling
Copy link
Contributor

Closing in favor of #10340

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
P-1 High priority; must be done this release T-missing-info
Projects
None yet
Development

No branches or pull requests

4 participants