Useful queries for popular relational databases to explore schema.

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)