SQL RENAME TABLE
This SQL tutorial explains how to use the SQL RENAME Table statement to change the name of a SQL table with syntax and example. SQL RENAME TABLE statement is used to change the name of an existing table. Sometime, we … Read more »
SQL DELETE Table
SQL DELETE TABLE statement is used to delete rows from an existing table. If you want to delete some specific row(s) from a table, you can use WHERE condition along with the SQL DELETE Table statement. SQL DELETE TABLE Syntax … Read more »
SQL DROP Table
SQL DROP Table statement is used to delete or drop a table from a database or SQL Schema. DROP Table statement removes all the data, indexes, triggers, constraints along with the definition of the table. So while issuing this statement … Read more »
SQL CREATE Table
SQL CREATE Table command is used to create a table in SQL. In order to create a table using SQL, you need a table name, column name and it’s datatypes. SQL CREATE Table Syntax Let’s check the basic syntax of … Read more »
SQL Select Database
In a real-world scenario, you will have multiple databases in your SQL Schema. In order to perform any kind of operations on the database, you need to select the database first. The SQL USE statement is used to select any … Read more »
SQL RENAME database
SQL RENAME DATABASE statement is used to rename a database. Sometime we need to rename database if in later stage stage we find that database name should be more relevant or if we want to create a temporary database. Now … Read more »
SQL DROP database
SQL DROP statement is used to drop or delete database objects from the schema. For example: If you want to drop a table you can user drop table statement. SQL DROP database statement is used to drop or delete databases … Read more »
SQL Create Database
In order to store and manipulate data in a database, you need to first create a database. This database subsequently holds tables and data. We are assuming that you already have MySQL or SQL server with you to use. If … Read more »
SQL Functions
SQL provides many built-in functions to perform calculations on data. Operations such as mathematical calculations, string manipulation like concatenation, substring are performed using these SQL Functions. SQL Functions broadly can be divided into the following two categories. Aggregate Functions Scalar … Read more »
SQL Keywords
SQL Keywords are the reserved words that are used to perform various operations in the database. These Keywords are case insensitive. For example, SELECT and select has the same meaning in SQL. List of SQL Keywords The available SQL Keywords … Read more »