Author Archives: user

SQL – Show Tables (Listing Tables) Table of content There are several instances when you need to retrieve a list of tables from your database. This could be done for testing purposes, to identify any existing tables before adding or removing any, or for any other reason. This tutorial will discuss how we can list […]

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 […]

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 […]