DbSchema Blog

DbSchema | MySQL - How to rename a Database

Learn how you can easily rename a MySQL database using mysqldump

Mysql • 10-May-2020

DbSchema | How to import a CSV file in MySql

Learn how to easily import a csv file to your MySQL database with a simple query.

Design • 05-May-2020

DbSchema | 3 ways to List All Schemas from PostgreSQL

This article contains 3 methods in which you can list all schemas in PostgreSQL

Postgresql • 27-Apr-2020

DbSchema | MySQL - How to DROP Foreign Key CONSTRAINTS

Learn how you can remove all foreign key constraints from a MySQL table using SQL language.

Mysql • 26-Apr-2020

DbSchema | 10+ Essential PostgreSQL Commands

In this article, we are going to list 20 essential PostgreSQL commands to help you manage your databases easily.

Postgresql • 14-Apr-2020

DbSchema | How to Show Tables in PostgreSQL

Discover different ways to show tables in a specific database using psql and querying pg_catalog schema in PostgreSQL. Also views, sequences, roles, objects

Postgresql • 14-Apr-2020

DbSchema | SQL Server - How to return Date Only from GETDATE

In this article, you will learn two ways that will help you return only the date from GETDATE.

Design • 13-Apr-2020

DbSchema vs Navicat, DbForge

This article compares the features, price, strengths & weaknesses of 3 database modeling tools: Navicat, DbForge and DbSchema

Design • 10-Apr-2020

DbSchema vs DbVisualizer

In this article, we compare the main features of DbSchema & DbVisualizer.

Design • 09-Apr-2020

DbSchema | How to Enable Remote Connections in SQL Server

Step-by-step guide on how to enable remote connections in SQL Server and set the Port

Design • 07-Apr-2020

DbSchema Blog

Categories