Classification of SQL Statements

SQL, technically speaking is a data sublanguage that is it is a language used to interact with database. In other words all SQL statements are instructions to the database only. And that is where it differs from general purpose programming languages like C or CPP. SQL provides many different types of commands used for different...

Data Definition Language (DDL)

A database scheme is specified by a set of definitions which are expressed by a special language called a data definition language DDL the result of compilation of DDL statements is a set of tables which are stored in a special file called data dictionary or directory. Whenever a data is read or modified in...