DbSchema Blog
Categories
- Cassandra
- Databases
- Dbschema features
- Design
- Firebird
- Migrations
- Mongodb
- Mysql
- Oracle
- Postgresql
- Release notes
- Snowflake
- Sql server
- Sqlite
- Tool comparisons
- Tools
- Tutorials
Creating an ER Diagram From an Existing Database
Learn how to connect a tool to a live database, reverse-engineer a schema into an ER diagram, and uncover undeclared foreign keys with DbSchema.
Design • 30-Sep-2026
pgAdmin ER Diagrams Compared With a Modelling Tool
How DbSchema's free Community Edition opens the PostgreSQL database behind pgAdmin's ERD tool, what that ERD does, and where a modelling tool goes further.
Tools • 30-Sep-2026
AI ER Diagram Generators Compared
Compare six AI ER diagram generators on input, output and where the model lives, and see how to draw an ER diagram from your real database instead.
Tools • 30-Sep-2026
Erwin Compared With ER/Studio and PowerDesigner
Compare erwin Data Modeler, ER/Studio, and PowerDesigner on repository features, cross-platform support, and team licensing costs for database architects.
Tools • 27-Sep-2026
DBeaver ER Diagrams and Where They Fall Short
Open, export and fix DBeaver ER diagrams, learn why relationship lines go missing, and know when to open the same database in DbSchema.
Tools • 27-Sep-2026
SQL Wildcard Characters: LIKE Patterns, ESCAPE Rules, and Examples | DbSchema
Learn SQL wildcard characters with %, _, ESCAPE, ILIKE, and NOT LIKE examples. Compare databases and test safe pattern searches in DbSchema.
Tutorials • 11-Sep-2026
SQL NULL Functions Explained with Examples | DbSchema
Learn SQL NULL-handling functions like IFNULL, ISNULL, COALESCE, and NVL, with examples, pitfalls, and practice exercises.
Tutorials • 11-Sep-2026
SQL HAVING Clause: GROUP BY Filters, Examples, and HAVING vs WHERE | DbSchema
Learn SQL HAVING with GROUP BY using COUNT, SUM, AVG, JOIN, and COUNT DISTINCT examples. Understand HAVING vs WHERE and write safer reporting queries.
Tutorials • 11-Sep-2026
SQL ANY and ALL Operators Explained with Examples | DbSchema
ANY is true when one subquery row matches, ALL only when every row does. See each operator form, IN and EXISTS, and what NULLs and an empty subquery do.
Tutorials • 11-Sep-2026
SQL SELECT INTO Statement Explained with Examples | DbSchema
SELECT INTO copies a query result into a new table. Syntax, examples with their results, what the copy keeps, and what to use on MySQL, Oracle and SQLite.
Tutorials • 11-Sep-2026