Category Archives: sql

SQL – Show Databases Table of content Many a times you face a situation where you need to list down all the available databases. MySQL provides a convenient way to list down all the databases using SHOW DATABASES command where as there is no particular command in MS SQL Server to show or list the […]

SQL – SELECT Database, USE Statement Table of content To work with a database in SQL, we need to first select the database we want to work with. After selecting the database, we can perform various operations on it such as creating tables, inserting data, updating data, and deleting data. The USE DATABASE Statement The […]

SQL – CREATE Table Table of content This tutorial will teach you how to use SQL to create tables in RDBMS. We use CREATE TABLE command to create a Table in a Database. In RDBMS, Database tables are used to store the data in the form of some structures (fields and records). Here, a field […]