Question : I’ve been tasked with writing an analysis of a database that is currently used on a small scale. […]
Tag: documentation
I think SQL Docs are wrong for sys.dm_db_index_physical_stats
Question : Go to this documentation page: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-physical-stats-transact-sql?view=sql-server-ver15 Then go to the index_level column explanation: The nonleaf levels of indexes […]
What is the syntax to add a constraint on an already-created table?
Question : PostgreSQL exclusion constraints are documented briefly under DDL-Constraints CREATE TABLE .. CONSTRAINT .. EXCLUDE As linked in ddl-constraint […]
How do you document your databases?
Question : I find that most of my clients are not documenting their databases at all and I find that […]
What does “through another column” mean in the MySQL docs?
Question : In the MySQL doc section on avoiding full table scans, one of the cases in which MySQL will […]
Is index_type ignored on MySQL primary keys in create table?
Question : I have seen a create table whose primary key had an identifier where it should have an index_type, […]
Documenting a collection of databases and their relationships with each other
Question : As part of a project I’m currently involved with we need to identify where various data points are […]
Can I export a MySQL schema to latex? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Shopping list question – questions about which […]
How do I navigate PostgreSQL documentation to find a list of all functions that work on a specific type?
Question : Let’s say I want to find a list of functions that can work on jsonb, what is the […]
Is there a postgres function documentation pattern that is similar in concept to javadoc?
Question : I am mostly a Java developer. Today I am writing some postgres functions. Out of habit I keep […]