1. Database Language is a special type of programming language used to define and manipulate a
database. These are four different types: DDL, DML, DCL, and TCL.
2. Data definition language (DDL) refers to the set of SQL commands that can create and manipulate the
structures of a database.
Common DDL statements include:
a) CREATE (generates a new table)
b) ALTER (alters table)
c) DROP (removes a table from the database)
a) The syntax for creating a table is this:
CREATE TABLE table name (field name data type);
For example this:
CREATE TABLE Artists (artistName, varchar);
b) the syntax for adding column in a table:
ALter table table_name
Add column_name datatype;
For example:
Alter table department
Add email varchar;
c) the syntax for removing a table:
