Chapter 3, Problem 3.46RQ

Program Plan Intro

SQL:

• SQL stands for “Structured Query Language”.
• The current version of SQL is “ANSI SQL – 92”.
• It contains constructs which are used to define and process database. They are executed using DBMS-supplied command prompt.
• SQL is not a programming language. It is text-based and it is also called as data sublanguage. In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on.

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

DELETE FROM statement:

“DELETE FROM” statement is used in order to delete existing records (rows and columns) from the table.

Note: It is necessary to use “WHERE” clause when deleting values, because, when it is ignored all the values from the mentioned column name gets deleted.

Syntax:

DELETE FROM table_Name WHERE condition;