Chapter 3, Problem 3.47RQ

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.

ALTER TABLE Statement:

“ALTER TABLE” statement comes under Data Definition Language. It is used to modify column, add constraints, add column(s), drop column, rename column name and table name, drop constraints, and so on. To add a new column, “ADD COLUMN” keyword should be used after mentioning the table name.

Syntax:

Syntax to add a column to an existing table is as follows: (The below query was executed in SQL Server Management Studio).

ALTER TABLE table_Name ADD COLUMN column_Name datatype;