DbSchema Blog

Categories

• Cassandra
• Databases
• Dbschema features
• Design
• Firebird
• Mongodb
• Mysql
• Oracle
• Postgresql
• Release notes
• Snowflake
• Sql server
• Sqlite
• Tutorials

Cassandra CREATE TABLE Guide in cqlsh and DbSchema

Learn how to create Cassandra tables in cqlsh and DbSchema, choose partition and clustering keys, and use table options without common modeling mistakes.

Cassandra • 18-May-2023

PostgreSQL CREATE PROCEDURE – IN/OUT Parameters, CALL, Transactions, and Errors | DbSchema

Learn PostgreSQL CREATE PROCEDURE with IN/OUT parameters, CALL syntax, transactions, and EXCEPTION handling. Compare procedures vs functions in DbSchema.

Postgresql • 16-May-2023

PostgreSQL CREATE INDEX Guide with psql and DbSchema | DbSchema

Learn how to create indexes in PostgreSQL using psql and DbSchema, including index options, limitations, and practical examples.

Postgresql • 16-May-2023

Drop Table in PostgreSQL – Syntax, IF EXISTS, CASCADE, and Safety Tips | DbSchema

Use DROP TABLE in PostgreSQL with IF EXISTS, CASCADE, and multi-table examples. Review dependencies first and manage changes visually in DbSchema.

Postgresql • 12-May-2023

Create Table in PostgreSQL – Syntax, Data Types, Constraints, and Examples | DbSchema

Create tables in PostgreSQL with practical syntax, data types, keys, defaults, and IF NOT EXISTS examples. Design and sync tables with DbSchema.

Postgresql • 12-May-2023

PostgreSQL CREATE DATABASE Guide with psql and DbSchema | DbSchema

Learn how to create a PostgreSQL database using psql and DbSchema, with setup steps, command examples, and verification tips.

Postgresql • 11-May-2023

MySQL INSERT INTO Guide with Practical Examples | DbSchema

Learn how to insert data into MySQL tables with SQL examples and visual data import workflows in DbSchema.

Mysql • 09-May-2023

MySQL DROP DATABASE Guide with Safety Checklist | DbSchema

Learn how to drop a MySQL database safely, verify deletion, and manage the operation visually in DbSchema.

Mysql • 09-May-2023

MySQL CREATE TABLE Guide with Examples | DbSchema

Learn how to create tables in MySQL with SQL commands, prerequisites, and visual design steps in DbSchema.

Mysql • 09-May-2023

MySQL CREATE DATABASE Guide for Beginners | DbSchema

Learn how to create a MySQL database from the command line, verify it, and manage it visually in DbSchema.

Mysql • 09-May-2023