Useful queries for popular relational databases to explore schema.
Most recent articles
- Find tables without primary keys (PKs) in Vertica database
- How many tables don't have primary keys (with percentage) in Vertica database
- Find tables that are not referenced by the foreign keys in Vertica database
- Find tables without relationships - Loner Tables - in Vertica database
- Compare default values of different columns with the same name in Vertica database