Database Data Dictionary Query Toolbox
Useful queries for popular relational databases to explore schema.
All databases
SQL Server
Azure SQL Database
Oracle database
MySQL
PostgreSQL
MariaDB
IBM Db2
Microsoft Access
Amazon Redshift
Snowflake
Teradata
Vertica
Most recent articles
- Find tables without primary keys (PKs) in Vertica database (Vertica)
- How many tables don't have primary keys (with percentage) in Vertica database (Vertica)
- Find tables that are not referenced by the foreign keys in Vertica database (Vertica)
- Find tables without relationships - Loner Tables - in Vertica database (Vertica)
- Compare default values of different columns with the same name in Vertica database (Vertica)
